DBA Data[Home] [Help]

APPS.INV_MGD_MVT_DATA_STR dependencies on MTL_MATERIAL_TRANSACTIONS

Line 41: transaction_type_id mtl_material_transactions.transaction_type_id%TYPE

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

Line 42: , transaction_action_id mtl_material_transactions.transaction_action_id%TYPE

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

Line 44: mtl_material_transactions.transfer_organization_id%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

Line 46: mtl_material_transactions.outside_processing_account%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

Line 47: , vendor_lot_number mtl_material_transactions.vendor_lot_number%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
51: , last_updated_by NUMBER := NULL

Line 48: , acct_period_id mtl_material_transactions.acct_period_id%TYPE

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

Line 49: , transaction_date mtl_material_transactions.transaction_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
53: );

Line 137: mtl_material_transactions.transfer_organization_id%TYPE

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

Line 288: , transaction_type_id mtl_material_transactions.transaction_type_id%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

Line 289: , transaction_action_id mtl_material_transactions.transaction_action_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