APPS.CSL_MTL_MAT_TRANS_ACC_PKG dependencies on MTL_MATERIAL_TRANSACTIONS

Line 8: g_table_name CONSTANT VARCHAR2(30) := 'MTL_MATERIAL_TRANSACTIONS';

4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_MTL_MAT_TRANS_ACC';
6: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
7: JTM_HOOK_UTIL_PKG.t_publication_item_list('MTL_MAT_TRANSACTIONS');
8: g_table_name CONSTANT VARCHAR2(30) := 'MTL_MATERIAL_TRANSACTIONS';
9: g_pk1_name CONSTANT VARCHAR2(30) := 'TRANSACTION_ID';
10: g_old_resource_id NUMBER; -- variable containing old resource_id; populated in Pre_Update hook
11: g_debug_level NUMBER; -- debug level
12:

Line 22: FROM MTL_MATERIAL_TRANSACTIONS

18: IS
19:
20: CURSOR c_mtl_mat_transactions (b_subinventory_code VARCHAR2, b_organization_id NUMBER) IS
21: SELECT TRANSACTION_ID, INVENTORY_ITEM_ID
22: FROM MTL_MATERIAL_TRANSACTIONS
23: WHERE SUBINVENTORY_CODE = p_SUBINVENTORY_CODE
24: AND ORGANIZATION_ID = b_organization_id
25: AND TRANSACTION_ACTION_ID = 2 --Subinventory transfer
26: AND SOURCE_CODE = 'CSP';

Line 118: FROM MTL_MATERIAL_TRANSACTIONS

114: IS
115:
116: CURSOR c_mtl_mat_transactions (b_subinventory_code VARCHAR2, b_organization_id NUMBER) IS
117: SELECT TRANSACTION_ID, INVENTORY_ITEM_ID
118: FROM MTL_MATERIAL_TRANSACTIONS
119: WHERE SUBINVENTORY_CODE = p_SUBINVENTORY_CODE
120: AND ORGANIZATION_ID = b_organization_id
121: AND TRANSACTION_ACTION_ID = 2 --Subinventory transfer
122: AND SOURCE_CODE = 'CSP';

Line 237: FROM MTL_MATERIAL_TRANSACTIONS

233: IS
234:
235: CURSOR c_mtl_mat_transactions (b_subinventory_code VARCHAR2, b_organization_id NUMBER) IS
236: SELECT TRANSACTION_ID, INVENTORY_ITEM_ID
237: FROM MTL_MATERIAL_TRANSACTIONS
238: WHERE SUBINVENTORY_CODE = p_SUBINVENTORY_CODE
239: AND ORGANIZATION_ID = b_organization_id
240: AND TRANSACTION_ACTION_ID = 2 --Subinventory transfer
241: AND SOURCE_CODE = 'CSP';