DBA Data[Home] [Help]

APPS.INV_LABEL_PVT4 dependencies on INV_GLOBALS

Line 2146: IF l_transaction_action_id IN (inv_globals.G_ACTION_SUBXFR,

2142: INTO l_transaction_action_id , l_src_subinventory_code ,
2143: l_src_locator_id ,l_src_lpn_id , l_src_organization_id
2144: FROM mtl_material_transactions_temp mmtt
2145: WHERE transaction_temp_id = p_transaction_id;
2146: IF l_transaction_action_id IN (inv_globals.G_ACTION_SUBXFR,
2147: inv_globals.G_ACTION_ORGXFR,
2148: inv_globals.G_ACTION_STGXFR,
2149: inv_globals.G_ACTION_CONTAINERPACK,
2150: inv_globals.G_ACTION_CONTAINERUNPACK) THEN --src status is required for only these transactions

Line 2147: inv_globals.G_ACTION_ORGXFR,

2143: l_src_locator_id ,l_src_lpn_id , l_src_organization_id
2144: FROM mtl_material_transactions_temp mmtt
2145: WHERE transaction_temp_id = p_transaction_id;
2146: IF l_transaction_action_id IN (inv_globals.G_ACTION_SUBXFR,
2147: inv_globals.G_ACTION_ORGXFR,
2148: inv_globals.G_ACTION_STGXFR,
2149: inv_globals.G_ACTION_CONTAINERPACK,
2150: inv_globals.G_ACTION_CONTAINERUNPACK) THEN --src status is required for only these transactions
2151: IF (l_debug = 1) THEN

Line 2148: inv_globals.G_ACTION_STGXFR,

2144: FROM mtl_material_transactions_temp mmtt
2145: WHERE transaction_temp_id = p_transaction_id;
2146: IF l_transaction_action_id IN (inv_globals.G_ACTION_SUBXFR,
2147: inv_globals.G_ACTION_ORGXFR,
2148: inv_globals.G_ACTION_STGXFR,
2149: inv_globals.G_ACTION_CONTAINERPACK,
2150: inv_globals.G_ACTION_CONTAINERUNPACK) THEN --src status is required for only these transactions
2151: IF (l_debug = 1) THEN
2152: trace('Transaction action id = '||l_transaction_action_id||' so need to check source status');

Line 2149: inv_globals.G_ACTION_CONTAINERPACK,

2145: WHERE transaction_temp_id = p_transaction_id;
2146: IF l_transaction_action_id IN (inv_globals.G_ACTION_SUBXFR,
2147: inv_globals.G_ACTION_ORGXFR,
2148: inv_globals.G_ACTION_STGXFR,
2149: inv_globals.G_ACTION_CONTAINERPACK,
2150: inv_globals.G_ACTION_CONTAINERUNPACK) THEN --src status is required for only these transactions
2151: IF (l_debug = 1) THEN
2152: trace('Transaction action id = '||l_transaction_action_id||' so need to check source status');
2153: END IF;

Line 2150: inv_globals.G_ACTION_CONTAINERUNPACK) THEN --src status is required for only these transactions

2146: IF l_transaction_action_id IN (inv_globals.G_ACTION_SUBXFR,
2147: inv_globals.G_ACTION_ORGXFR,
2148: inv_globals.G_ACTION_STGXFR,
2149: inv_globals.G_ACTION_CONTAINERPACK,
2150: inv_globals.G_ACTION_CONTAINERUNPACK) THEN --src status is required for only these transactions
2151: IF (l_debug = 1) THEN
2152: trace('Transaction action id = '||l_transaction_action_id||' so need to check source status');
2153: END IF;
2154: BEGIN --querying for source status