--多语言视图
ALTER SESSION SET NLS_LANGUAGE=AMERICAN ;
--组织化视图
BEGIN
FND_CLIENT_INFO.set_org_context(218);
END;
--组织化视图 R12
BEGIN
mo_global.set_policy_context('S', 218);
END;
--customer
select * from ar_customers t where t.customer_number = '74213';
select * from ar_addresses_v t where t.customer_id = 112332;
select * from ar_site_uses_v t where t.site_use_id = 630028;
select * from ar_addresses_v t where t.address_id = 449831;
HZ_CUST_ACCOUNTS hca,
HZ_CUST_SITE_USES_ALL subill,
HZ_PARTIES hp,
---header / line
SELECT t.flow_status_code, t.header_id, t.*
FROM oe_order_headers_all t
WHERE t.order_number = 1789703;
SELECT t.flow_status_code, t.line_id FROM oe_order_lines_all t WHERE t.header_id = 10186257
--wsh_delivery
SELECT t.released_status, t.mvt_stat_status, t.*
FROM wsh_delivery_details t
WHERE t.source_code = 'OE'
AND t.source_header_id = 10186257;
SELECT * FROM wsh_delivery_assignments t WHERE t.delivery_detail_id = 120302363;
-- create dn
SELECT * FROM wsh_new_deliveries t WHERE t.delivery_id = 9551901;
--WIP
SELECT * FROM wip_entities t WHERE t.wip_entity_name = '9127901'; --工单号,\
SELECT * FROM wip_discrete_jobs t WHERE t.wip_entity_id = 11480764;
SELECT * FROM wip_operations t WHERE t.wip_entity_id = 11480764;
SELECT * FROM mtl_material_transactions t where t.transaction_source_id =11480764; --wip_entity_id
--picked release
SELECT * FROM wsh_picking_batches t WHERE t.batch_id IN (26799701) --PICKED界面
and t.order_header_id =10186257;
SELECT * FROM mtl_txn_request_lines t WHERE t.line_id = 143329081; --move_order_line_id
SELECT * FROM mtl_txn_request_headers t WHERE t.header_id = 26799702;
SELECT * FROM mtl_material_transactions_temp t WHERE t.move_order_line_id =143329081
--move order / picked confirm
SELECT t.transaction_id,t.* FROM wsh_pick_slip_v t WHERE t.move_order_line_id = 143329081;
SELECT t.transaction_set_id, t.* FROM mtl_material_transactions t WHERE t.move_order_line_id = 143329081;--t.transaction_id =1877112298;
SELECT * FROM mtl_material_transactions t WHERE t.transaction_set_id = 1877112297;
--ship confirmed
SELECT * FROM mtl_material_transactions t WHERE t.picking_line_id = 120302363; --delivery_detail_id
SELECT * FROM mtl_material_transactions t WHERE t.source_line_id =346400869; --oe_line_id
select t.pick_up_stop_id, t.drop_off_stop_id, t.* from wsh_delivery_legs t where t.delivery_id = 9551901;
select t.trip_id, t.* from wsh_trip_stops t where t.stop_id in (13939361, 13939362);
select * from wsh_trips t where t.trip_id = 6962260;
--ar interface
select * from ar.ra_interface_lines_all t where t.interface_line_attribute1 ='1789703' --order_number
--return order
SELECT t.flow_status_code, t.header_id, t.*
FROM oe_order_headers_all t
WHERE t.order_number = 4320045;
SELECT t.flow_status_code, t.line_id FROM oe_order_lines_all t WHERE t.header_id = 10186351;
--Receipts
select * from rcv_shipment_headers r where r.receipt_num ='4320045-r';
select * from rcv_shipment_lines l where l.shipment_header_id =7143290;
select * from rcv_transactions_interface l where l.shipment_header_id =7143290;
select * from rcv_transactions t where t.shipment_header_id =7143290;
--入库
select * from mtl_material_transactions mmt where mmt.Rcv_Transaction_Id =95826257;
--ar interface
select * from ar.ra_interface_lines_all t where t.interface_line_attribute1 ='4320045' --order_number