APPS.CSM_MTL_MATERIAL_TXN_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) := 'CSM_MTL_MATERIAL_TXN_ACC';
6: g_publication_item_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
7: CSM_ACC_PKG.t_publication_item_list('CSM_MTL_MATERIAL_TXNS');
8: g_table_name CONSTANT VARCHAR2(30) := 'MTL_MATERIAL_TRANSACTIONS';
9: g_tasks_seq_name CONSTANT VARCHAR2(30) := 'CSM_MTL_MATERIAL_TXN_ACC_S';
10: g_pk1_name CONSTANT VARCHAR2(30) := 'TRANSACTION_ID';
11:
12: PROCEDURE Insert_MTL_Mat_Transaction(

Line 196: MTL_MATERIAL_TRANSACTIONS B

192: IS
193: SELECT ACC.user_id
194: , ACC.TRANSACTION_ID
195: FROM CSM_MTL_MATERIAL_TXN_ACC ACC,
196: MTL_MATERIAL_TRANSACTIONS B
197: WHERE B.TRANSACTION_ID = ACC.TRANSACTION_ID
198: AND B.TRANSACTION_ACTION_ID = 2 --Subinventory transfer
199: And (
200: B.transaction_date < (sysdate - c_history_profile)

Line 225: MTL_MATERIAL_TRANSACTIONS B

221: CURSOR l_mat_update_csr (b_last_run_date IN DATE) IS
222: SELECT ACC.user_id
223: , ACC.TRANSACTION_ID
224: FROM CSM_MTL_MATERIAL_TXN_ACC ACC,
225: MTL_MATERIAL_TRANSACTIONS B
226: WHERE B.TRANSACTION_ID = ACC.TRANSACTION_ID
227: AND B.last_update_date > b_last_run_date;
228:
229: --Insert if either from OR to subinv are assigned to the mobile user

Line 234: FROM MTL_MATERIAL_TRANSACTIONS B,

230: CURSOR l_mat_insert_csr (c_history_profile NUMBER)
231: IS
232: SELECT cilaa.user_id
233: , B.TRANSACTION_ID
234: FROM MTL_MATERIAL_TRANSACTIONS B,
235: csm_inv_loc_ass_acc cilaa,
236: csp_inv_loc_assignments cila_from
237: WHERE cilaa.csp_inv_loc_assignment_id = cila_from.csp_inv_loc_assignment_id
238: AND TRANSACTION_ACTION_ID = 2 --Subinventory transfer

Line 249: FROM MTL_MATERIAL_TRANSACTIONS B,

245: AND B.transaction_date > (sysdate - c_history_profile)
246: UNION ALL
247: SELECT cilaa.user_id
248: , B.TRANSACTION_ID
249: FROM MTL_MATERIAL_TRANSACTIONS B,
250: csm_inv_loc_ass_acc cilaa,
251: csp_inv_loc_assignments cila_to
252: WHERE cilaa.csp_inv_loc_assignment_id = cila_to.csp_inv_loc_assignment_id
253: AND TRANSACTION_ACTION_ID = 2 --Subinventory transfer

Line 264: TYPE tran_idTab IS TABLE OF MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;

260: AND ACC.USER_ID = cilaa.USER_ID);
261:
262: l_last_run_date jtm_con_request_data.last_run_date%TYPE;
263:
264: TYPE tran_idTab IS TABLE OF MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
265:
266: l_user_id_lst ASG_DOWNLOAD.USER_LIST;
267: l_tran_id_lst tran_idTab;
268:

Line 409: FROM MTL_MATERIAL_TRANSACTIONS B

405:
406: --Insert if either from OR to subinv are assigned to the mobile user
407: CURSOR l_mat_insert_csr (b_user_id IN NUMBER, b_profile_value NUMBER) IS
408: SELECT B.TRANSACTION_ID
409: FROM MTL_MATERIAL_TRANSACTIONS B
410: WHERE B.transaction_date > (sysdate - b_profile_value)
411: AND B.TRANSACTION_ACTION_ID = 2 --Subinventory transfer
412: AND EXISTS( SELECT 1
413: FROM csm_inv_loc_ass_acc cilaa1,

Line 425: FROM MTL_MATERIAL_TRANSACTIONS B

421: WHERE B.TRANSACTION_ID = ACC.TRANSACTION_ID
422: AND ACC.USER_ID = b_user_id)
423: UNION ALL
424: SELECT B.TRANSACTION_ID
425: FROM MTL_MATERIAL_TRANSACTIONS B
426: WHERE B.transaction_date > (sysdate - b_profile_value)
427: AND B.TRANSACTION_ACTION_ID = 2 --Subinventory transfer
428: AND EXISTS (SELECT 1
429: FROM csm_inv_loc_ass_acc cilaa2,

Line 442: TYPE Tran_idTab IS TABLE OF MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;

438: AND ACC.USER_ID = b_user_id);
439:
440:
441:
442: TYPE Tran_idTab IS TABLE OF MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
443:
444: l_tran_id_lst Tran_idTab;
445:
446: l_sqlerrno VARCHAR2(20);