DBA Data[Home] [Help]

APPS.INVTTMTX dependencies on MTL_TRANSACTIONS_INTERFACE

Line 123: FROM mtl_transactions_interface m

119: conditions to check transaction_type_id and transaction_action_id
120: to query for only Transaction Type Inter-Org Transfer*/
121: SELECT shipment_number
122: INTO found_row
123: FROM mtl_transactions_interface m
124: WHERE m.shipment_number = vall
125: AND m.transaction_type_id = INV_GLOBALS.G_SOURCETYPE_INVENTORY
126: AND m.transaction_action_id= INV_GLOBALS.G_ACTION_INTRANSITSHIPMENT
127: AND ROWNUM = 1 ;