APPS.CSM_MTL_SEC_LOCATORS_EVENT_PKG dependencies on CSM_MTL_SECONDARY_LOCATORS_ACC

Line 15: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_SECONDARY_LOCATORS_ACC';

11: -- --------- ------ ------------------------------------------
12: -- Enter procedure, function bodies as shown below
13:
14: g_table_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_SECONDARY_LOCATORS';
15: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_SECONDARY_LOCATORS_ACC';
16: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_SEC_LOCATORS_ACC_S';
17: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
18: CSM_ACC_PKG.t_publication_item_list('CSM_MTL_SECONDARY_LOCATORS');
19: g_pk1_name1 CONSTANT VARCHAR2(30) := 'INVENTORY_ITEM_ID';

Line 66: FROM csm_mtl_secondary_locators_acc acc

62: AND msl.organization_id = mil_acc.organization_id
63: AND msi_acc.user_id = mil_acc.user_id
64: AND NOT EXISTS
65: (SELECT 1
66: FROM csm_mtl_secondary_locators_acc acc
67: WHERE acc.user_id = msi_acc.user_id
68: AND acc.inventory_item_id = msi_acc.inventory_item_id
69: AND acc.organization_id = msi_acc.organization_id
70: AND acc.secondary_locator = msl.secondary_locator

Line 87: FROM csm_mtl_secondary_locators_acc acc

83: AND msi_acc.user_id = -1
84: AND mil_acc.user_id = uorg.user_id
85: AND msi_acc.organization_id=uorg.organization_id
86: AND NOT EXISTS(SELECT 1
87: FROM csm_mtl_secondary_locators_acc acc
88: WHERE acc.user_id = mil_acc.user_id
89: AND acc.inventory_item_id = msl.inventory_item_id
90: AND acc.organization_id = msl.organization_id
91: AND acc.secondary_locator = msl.secondary_locator

Line 99: FROM csm_mtl_secondary_locators_acc acc,

95: CURSOR l_mtl_sec_loc_upd_csr(p_last_upd_date DATE)
96: IS
97: SELECT acc.access_id, acc.secondary_locator, acc.organization_id,
98: acc.inventory_item_id, acc.user_id
99: FROM csm_mtl_secondary_locators_acc acc,
100: mtl_secondary_locators msl
101: WHERE msl.secondary_locator = acc.secondary_locator
102: AND msl.organization_id = acc.organization_id
103: AND msl.inventory_item_id = acc.inventory_item_id

Line 110: FROM csm_mtl_secondary_locators_acc acc

106: -- process deletes
107: CURSOR l_mtl_sec_loc_del_csr
108: IS
109: SELECT acc.user_id, acc.secondary_locator, acc.organization_id, acc.inventory_item_id
110: FROM csm_mtl_secondary_locators_acc acc
111: WHERE NOT EXISTS
112: ((SELECT 1
113: FROM csm_mtl_system_items_acc msi_acc,
114: csm_mtl_item_locations_acc mil_acc,