37: -- to populate mtl_movement_statistics for transaction type INVENTORY
38:
39: TYPE Material_Transaction_Rec_Type IS RECORD
40: (
41: transaction_type_id mtl_material_transactions.transaction_type_id%TYPE
42: , transaction_action_id mtl_material_transactions.transaction_action_id%TYPE
43: , transfer_organization_id
44: mtl_material_transactions.transfer_organization_id%TYPE
45: , outside_processing_account
38:
39: TYPE Material_Transaction_Rec_Type IS RECORD
40: (
41: transaction_type_id mtl_material_transactions.transaction_type_id%TYPE
42: , transaction_action_id mtl_material_transactions.transaction_action_id%TYPE
43: , transfer_organization_id
44: mtl_material_transactions.transfer_organization_id%TYPE
45: , outside_processing_account
46: mtl_material_transactions.outside_processing_account%TYPE
40: (
41: transaction_type_id mtl_material_transactions.transaction_type_id%TYPE
42: , transaction_action_id mtl_material_transactions.transaction_action_id%TYPE
43: , transfer_organization_id
44: mtl_material_transactions.transfer_organization_id%TYPE
45: , outside_processing_account
46: mtl_material_transactions.outside_processing_account%TYPE
47: , vendor_lot_number mtl_material_transactions.vendor_lot_number%TYPE
48: , acct_period_id mtl_material_transactions.acct_period_id%TYPE
42: , transaction_action_id mtl_material_transactions.transaction_action_id%TYPE
43: , transfer_organization_id
44: mtl_material_transactions.transfer_organization_id%TYPE
45: , outside_processing_account
46: mtl_material_transactions.outside_processing_account%TYPE
47: , vendor_lot_number mtl_material_transactions.vendor_lot_number%TYPE
48: , acct_period_id mtl_material_transactions.acct_period_id%TYPE
49: , transaction_date mtl_material_transactions.transaction_id%TYPE
50: , last_update_date DATE := NULL
43: , transfer_organization_id
44: mtl_material_transactions.transfer_organization_id%TYPE
45: , outside_processing_account
46: mtl_material_transactions.outside_processing_account%TYPE
47: , vendor_lot_number mtl_material_transactions.vendor_lot_number%TYPE
48: , acct_period_id mtl_material_transactions.acct_period_id%TYPE
49: , transaction_date mtl_material_transactions.transaction_id%TYPE
50: , last_update_date DATE := NULL
51: , last_updated_by NUMBER := NULL
44: mtl_material_transactions.transfer_organization_id%TYPE
45: , outside_processing_account
46: mtl_material_transactions.outside_processing_account%TYPE
47: , vendor_lot_number mtl_material_transactions.vendor_lot_number%TYPE
48: , acct_period_id mtl_material_transactions.acct_period_id%TYPE
49: , transaction_date mtl_material_transactions.transaction_id%TYPE
50: , last_update_date DATE := NULL
51: , last_updated_by NUMBER := NULL
52: , last_update_login NUMBER := NULL
45: , outside_processing_account
46: mtl_material_transactions.outside_processing_account%TYPE
47: , vendor_lot_number mtl_material_transactions.vendor_lot_number%TYPE
48: , acct_period_id mtl_material_transactions.acct_period_id%TYPE
49: , transaction_date mtl_material_transactions.transaction_id%TYPE
50: , last_update_date DATE := NULL
51: , last_updated_by NUMBER := NULL
52: , last_update_login NUMBER := NULL
53: );
133: , customer_location mtl_movement_statistics.customer_location%TYPE
134: , transacting_from_org mtl_movement_statistics.transacting_from_org%TYPE
135: , transacting_to_org mtl_movement_statistics.transacting_to_org%TYPE
136: , transfer_organization_id
137: mtl_material_transactions.transfer_organization_id%TYPE
138: , vendor_name mtl_movement_statistics.vendor_name%TYPE
139: , vendor_number mtl_movement_statistics.vendor_number%TYPE
140: , vendor_site mtl_movement_statistics.vendor_site%TYPE
141: , bill_to_name mtl_movement_statistics.bill_to_name%TYPE
284: , edi_transaction_date
285: mtl_movement_statistics.edi_transaction_date%TYPE
286: , esl_drop_shipment_code mtl_movement_statistics.esl_drop_shipment_code%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
285: mtl_movement_statistics.edi_transaction_date%TYPE
286: , esl_drop_shipment_code mtl_movement_statistics.esl_drop_shipment_code%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