DBA Data[Home] [Help]

APPS.INV_MGD_MVT_DATA_STR dependencies on OE_ORDER_HEADERS_ALL

Line 89: , so_org_id oe_order_headers_all.org_id%TYPE

85:
86: TYPE Shipment_Transaction_Rec_Type IS RECORD
87: (
88: org_id wsh_delivery_details.org_id%TYPE
89: , so_org_id oe_order_headers_all.org_id%TYPE
90: , shipped_quantity oe_order_lines_all.shipped_quantity%TYPE
91: , last_update_date DATE := NULL
92: , last_updated_by NUMBER := NULL
93: , last_update_login NUMBER := NULL

Line 98: , req_num oe_order_headers_all.orig_sys_document_ref%TYPE

94: , drop_ship_source_id oe_drop_ship_sources.drop_ship_source_id%TYPE
95: , destination_org_id
96: oe_drop_ship_sources.destination_organization_id%TYPE
97: , req_line_num oe_order_lines_all.orig_sys_line_ref%TYPE
98: , req_num oe_order_headers_all.orig_sys_document_ref%TYPE
99: , order_source_id oe_order_headers_all.order_source_id%TYPE
100: , mvt_stat_status wsh_delivery_details.mvt_stat_status%TYPE
101: );
102:

Line 99: , order_source_id oe_order_headers_all.order_source_id%TYPE

95: , destination_org_id
96: oe_drop_ship_sources.destination_organization_id%TYPE
97: , req_line_num oe_order_lines_all.orig_sys_line_ref%TYPE
98: , req_num oe_order_headers_all.orig_sys_document_ref%TYPE
99: , order_source_id oe_order_headers_all.order_source_id%TYPE
100: , mvt_stat_status wsh_delivery_details.mvt_stat_status%TYPE
101: );
102:
103:

Line 259: , order_number oe_order_headers_all.order_number%TYPE

255: , usage_type mtl_movement_statistics.usage_type%TYPE
256: , zone_code mtl_movement_statistics.zone_code%TYPE
257: , edi_sent_flag mtl_movement_statistics.edi_sent_flag%TYPE
258: , movement_amount mtl_movement_statistics.movement_amount%TYPE
259: , order_number oe_order_headers_all.order_number%TYPE
260: , line_number oe_order_lines_all.line_number%TYPE
261: , triangulation_country_code
262: mtl_movement_statistics.triangulation_country_code%TYPE
263: , csa_code mtl_movement_statistics.csa_code%TYPE

Line 291: , org_id oe_order_headers_all.org_id%TYPE

287: , customer_vat_number mtl_movement_statistics.customer_vat_number%TYPE
288: , transaction_type_id mtl_material_transactions.transaction_type_id%TYPE
289: , transaction_action_id mtl_material_transactions.transaction_action_id%TYPE
290: --, opm_trans_id NUMBER
291: , org_id oe_order_headers_all.org_id%TYPE
292: , release_id rcv_transactions.po_release_id%TYPE
293: , type_lookup_code po_headers_all.type_lookup_code%TYPE
294: , reference_date DATE
295: , consigned_flag rcv_transactions.consigned_flag%TYPE

Line 296: , sold_from_org_id oe_order_headers_all.sold_from_org_id%TYPE -- 7165989

292: , release_id rcv_transactions.po_release_id%TYPE
293: , type_lookup_code po_headers_all.type_lookup_code%TYPE
294: , reference_date DATE
295: , consigned_flag rcv_transactions.consigned_flag%TYPE
296: , sold_from_org_id oe_order_headers_all.sold_from_org_id%TYPE -- 7165989
297: );
298:
299: --Bug: 5920143. New column include_establishments has beed added in
300: -- record definition.