DBA Data[Home] [Help]

APPS.INVTTMTX dependencies on INV_GLOBALS

Line 125: AND m.transaction_type_id = INV_GLOBALS.G_SOURCETYPE_INVENTORY

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 ;
128:
129: return 0;

Line 126: AND m.transaction_action_id= INV_GLOBALS.G_ACTION_INTRANSITSHIPMENT

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 ;
128:
129: return 0;
130:

Line 137: AND m.transaction_type_id = INV_GLOBALS.G_SOURCETYPE_INVENTORY

133: SELECT shipment_number
134: INTO found_row
135: FROM mtl_material_transactions_temp m
136: WHERE m.shipment_number = vall
137: AND m.transaction_type_id = INV_GLOBALS.G_SOURCETYPE_INVENTORY
138: AND m.transaction_action_id= INV_GLOBALS.G_ACTION_INTRANSITSHIPMENT
139: AND ROWNUM = 1 ;
140:
141: return 0;

Line 138: AND m.transaction_action_id= INV_GLOBALS.G_ACTION_INTRANSITSHIPMENT

134: INTO found_row
135: FROM mtl_material_transactions_temp m
136: WHERE m.shipment_number = vall
137: AND m.transaction_type_id = INV_GLOBALS.G_SOURCETYPE_INVENTORY
138: AND m.transaction_action_id= INV_GLOBALS.G_ACTION_INTRANSITSHIPMENT
139: AND ROWNUM = 1 ;
140:
141: return 0;
142: