eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_MTL_MATERIAL_TXN_ACC_PKG dependencies on CSM_PROFILE_PKG

Line 215: B.transaction_date < (sysdate - CSM_PROFILE_PKG.get_task_history_days(acc.user_id))

211: AND cilaa.user_id = ACC.user_id
212: AND cila.subinventory_code = B.transfer_subinventory
213: AND cila.organization_id = B.transfer_organization_id)
214: OR
215: B.transaction_date < (sysdate - CSM_PROFILE_PKG.get_task_history_days(acc.user_id))
216: );
217:
218: -- get the updates to mat trfr
219: CURSOR l_mat_update_csr (b_last_run_date IN DATE) IS

Line 243: AND B.transaction_date > (sysdate -CSM_PROFILE_PKG.get_task_history_days(cilaa.user_id))

239: AND NVL(cila_from.locator_id,0) = NVL(B.locator_id,0)
240: AND NOT EXISTS (SELECT 1 FROM CSM_MTL_MATERIAL_TXN_ACC ACC
241: WHERE B.TRANSACTION_ID = ACC.TRANSACTION_ID
242: AND ACC.USER_ID = cilaa.USER_ID)
243: AND B.transaction_date > (sysdate -CSM_PROFILE_PKG.get_task_history_days(cilaa.user_id))
244: UNION ALL
245: SELECT cilaa.user_id
246: , B.TRANSACTION_ID
247: FROM MTL_MATERIAL_TRANSACTIONS B,

Line 255: AND B.transaction_date > (sysdate -CSM_PROFILE_PKG.get_task_history_days(cilaa.user_id))

251: AND TRANSACTION_ACTION_ID = 2 --Subinventory transfer
252: AND cila_to.subinventory_code = B.transfer_subinventory
253: AND cila_to.organization_id = B.transfer_organization_id
254: AND NVL(cila_to.locator_id,0) = NVL(B.transfer_locator_id,0)
255: AND B.transaction_date > (sysdate -CSM_PROFILE_PKG.get_task_history_days(cilaa.user_id))
256: AND NOT EXISTS (SELECT 1 FROM CSM_MTL_MATERIAL_TXN_ACC ACC
257: WHERE B.TRANSACTION_ID = ACC.TRANSACTION_ID
258: AND ACC.USER_ID = cilaa.USER_ID);
259:

Line 416: AND B.transaction_date > (sysdate -CSM_PROFILE_PKG.get_task_history_days(cilaa.user_id))

412: AND NVL(cila_from.locator_id,0) = NVL(B.locator_id,0)
413: AND NOT EXISTS (SELECT 1 FROM CSM_MTL_MATERIAL_TXN_ACC ACC
414: WHERE B.TRANSACTION_ID = ACC.TRANSACTION_ID)
415: AND cilaa.user_id = b_user_id
416: AND B.transaction_date > (sysdate -CSM_PROFILE_PKG.get_task_history_days(cilaa.user_id))
417: UNION ALL
418: SELECT B.TRANSACTION_ID
419: FROM MTL_MATERIAL_TRANSACTIONS B,
420: csm_inv_loc_ass_acc cilaa,

Line 430: AND B.transaction_date > (sysdate -CSM_PROFILE_PKG.get_task_history_days(cilaa.user_id));

426: AND NVL(cila_to.locator_id,0) = NVL(B.transfer_locator_id,0)
427: AND NOT EXISTS (SELECT 1 FROM CSM_MTL_MATERIAL_TXN_ACC ACC
428: WHERE B.TRANSACTION_ID = ACC.TRANSACTION_ID)
429: AND cilaa.user_id = b_user_id
430: AND B.transaction_date > (sysdate -CSM_PROFILE_PKG.get_task_history_days(cilaa.user_id));
431:
432: TYPE Tran_idTab IS TABLE OF MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
433:
434: l_tran_id_lst Tran_idTab;