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_SYSTEM_ITEMS_EVENT_PKG dependencies on CSM_MTL_SYSTEM_ITEMS_ACC_S

Line 19: g_mtl_sys_items_seq_name CONSTANT VARCHAR2(30) := 'CSM_MTL_SYSTEM_ITEMS_ACC_S' ;

15:
16: /*** Globals ***/
17: g_mtl_sys_items_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_MTL_SYSTEM_ITEMS_ACC';
18: g_mtl_sys_items_table_name CONSTANT VARCHAR2(30) := 'CS_MTL_SYSTEM_ITEMS';
19: g_mtl_sys_items_seq_name CONSTANT VARCHAR2(30) := 'CSM_MTL_SYSTEM_ITEMS_ACC_S' ;
20: g_mtl_sys_items_pk1_name CONSTANT VARCHAR2(30) := 'INVENTORY_ITEM_ID';
21: g_mtl_sys_items_pk2_name CONSTANT VARCHAR2(30) := 'ORGANIZATION_ID';
22: g_mtl_sys_items_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
23: CSM_ACC_PKG.t_publication_item_list('CSM_MTL_SYSTEM_ITEMS');

Line 54: SELECT csm_mtl_system_items_acc_s.NEXTVAL, inventory_item_id, organization_id, b_user_id

50: -- Both category and cat set are null
51: CURSOR c_items (b_user_id NUMBER, b_organization_id NUMBER,
52: b_changed VARCHAR2, b_last_run_date DATE)
53: IS
54: SELECT csm_mtl_system_items_acc_s.NEXTVAL, inventory_item_id, organization_id, b_user_id
55: FROM MTL_SYSTEM_ITEMS_B msi
56: WHERE msi.organization_id = b_organization_id
57: AND (b_changed = 'Y'
58: OR msi.creation_date >= NVL(b_last_run_date, msi.creation_date))

Line 70: SELECT csm_mtl_system_items_acc_s.NEXTVAL, inventory_item_id, organization_id, b_user_id

66: -- Category is not null and Cat set is null
67: CURSOR c_items_Cat (b_user_id NUMBER, b_organization_id NUMBER,
68: b_changed VARCHAR2, b_last_run_date DATE, b_category_id NUMBER)
69: IS
70: SELECT csm_mtl_system_items_acc_s.NEXTVAL, inventory_item_id, organization_id, b_user_id
71: FROM mtl_system_items_b msi
72: WHERE NOT EXISTS
73: (SELECT 1
74: FROM csm_mtl_system_items_acc acc

Line 94: SELECT csm_mtl_system_items_acc_s.NEXTVAL, inventory_item_id, organization_id, b_user_id

90: -- Category is null and Cat Set is not null
91: CURSOR c_items_Cat_Set (b_user_id NUMBER, b_organization_id NUMBER,
92: b_changed VARCHAR2, b_last_run_date DATE, b_category_set_id NUMBER)
93: IS
94: SELECT csm_mtl_system_items_acc_s.NEXTVAL, inventory_item_id, organization_id, b_user_id
95: FROM mtl_system_items_b msi
96: WHERE NOT EXISTS
97: (SELECT 1
98: FROM csm_mtl_system_items_acc acc

Line 118: SELECT csm_mtl_system_items_acc_s.NEXTVAL, inventory_item_id, organization_id, b_user_id

114: -- Both Category and Category set are not null
115: CURSOR c_items_Cat_Set_Cat (b_user_id NUMBER, b_organization_id NUMBER,
116: b_changed VARCHAR2, b_last_run_date DATE, b_category_id NUMBER, b_category_set_id NUMBER)
117: IS
118: SELECT csm_mtl_system_items_acc_s.NEXTVAL, inventory_item_id, organization_id, b_user_id
119: FROM mtl_system_items_b msi
120: WHERE NOT EXISTS
121: (SELECT 1
122: FROM csm_mtl_system_items_acc acc