DBA Data[Home] [Help]

APPS.INV_MGD_MVT_DATA_STR dependencies on WSH_DELIVERY_DETAILS

Line 88: org_id wsh_delivery_details.org_id%TYPE

84: -- to populate mtl_movement_statistics for transaction type SALES ORDER
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

Line 100: , mvt_stat_status wsh_delivery_details.mvt_stat_status%TYPE

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:
104: TYPE Movement_Transaction_Rec_Type IS RECORD

Line 169: , shipped_quantity wsh_delivery_details.shipped_quantity%TYPE

165: , transaction_quantity mtl_movement_statistics.transaction_quantity%TYPE
166: , transaction_uom_code mtl_movement_statistics.transaction_uom_code%TYPE
167: , primary_quantity mtl_movement_statistics.primary_quantity%TYPE
168: , primary_uom_code mtl_movement_statistics.transaction_uom_code%TYPE
169: , shipped_quantity wsh_delivery_details.shipped_quantity%TYPE
170: , invoice_batch_id mtl_movement_statistics.invoice_batch_id%TYPE
171: , invoice_id mtl_movement_statistics.invoice_id%TYPE
172: , customer_trx_line_id mtl_movement_statistics.customer_trx_line_id%TYPE
173: , invoice_batch_reference