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 78: FROM csm_mtl_secondary_locators_acc acc,

74: CURSOR l_mtl_sec_loc_upd_csr(p_last_upd_date DATE)
75: IS
76: SELECT acc.access_id, acc.secondary_locator, acc.organization_id,
77: acc.inventory_item_id, acc.user_id
78: FROM csm_mtl_secondary_locators_acc acc,
79: mtl_secondary_locators msl
80: WHERE msl.secondary_locator = acc.secondary_locator
81: AND msl.organization_id = acc.organization_id
82: AND msl.inventory_item_id = acc.inventory_item_id

Line 89: FROM csm_mtl_secondary_locators_acc acc

85: -- process deletes
86: CURSOR l_mtl_sec_loc_del_csr
87: IS
88: SELECT acc.user_id, acc.secondary_locator, acc.organization_id, acc.inventory_item_id
89: FROM csm_mtl_secondary_locators_acc acc
90: WHERE NOT EXISTS
91: (SELECT 1
92: FROM csm_mtl_system_items_acc msi_acc,
93: csm_mtl_item_locations_acc mil_acc,