APPS.CSM_MTL_SEC_LOCATORS_EVENT_PKG dependencies on CSM_MTL_SYSTEM_ITEMS_ACC

Line 56: FROM csm_mtl_system_items_acc msi_acc,

52: CURSOR l_mtl_sec_loc_ins_csr
53: IS
54: SELECT msi_acc.user_id, msl.inventory_item_id,
55: msl.organization_id, msl.secondary_locator
56: FROM csm_mtl_system_items_acc msi_acc,
57: csm_mtl_item_locations_acc mil_acc,
58: mtl_secondary_locators msl
59: WHERE msl.inventory_item_id = msi_acc.inventory_item_id
60: AND msl.organization_id = msi_acc.organization_id

Line 75: FROM csm_mtl_system_items_acc msi_acc,

71: )
72: UNION ALL
73: SELECT mil_acc.user_id, msl.inventory_item_id,
74: msl.organization_id, msl.secondary_locator
75: FROM csm_mtl_system_items_acc msi_acc,
76: csm_mtl_item_locations_acc mil_acc,
77: mtl_secondary_locators msl,
78: csm_user_inventory_org uorg
79: WHERE msl.inventory_item_id = msi_acc.inventory_item_id

Line 113: FROM csm_mtl_system_items_acc msi_acc,

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,
115: mtl_secondary_locators msl
116: WHERE msl.inventory_item_id = msi_acc.inventory_item_id
117: AND msl.organization_id = msi_acc.organization_id

Line 128: FROM csm_mtl_system_items_acc msi_acc,

124: AND acc.user_id = msi_acc.user_id
125: )
126: UNION ALL
127: (SELECT 1
128: FROM csm_mtl_system_items_acc msi_acc,
129: csm_mtl_item_locations_acc mil_acc,
130: mtl_secondary_locators msl,
131: csm_user_inventory_org uorg
132: WHERE msl.inventory_item_id = msi_acc.inventory_item_id