APPS.CSM_MTL_SEC_LOCATORS_EVENT_PKG dependencies on CSM_MTL_ITEM_LOCATIONS_ACC

Line 57: csm_mtl_item_locations_acc mil_acc,

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
61: AND msl.secondary_locator = mil_acc.inventory_location_id

Line 76: csm_mtl_item_locations_acc mil_acc,

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
80: AND msl.organization_id = msi_acc.organization_id

Line 114: csm_mtl_item_locations_acc mil_acc,

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
118: AND msl.secondary_locator = mil_acc.inventory_location_id

Line 129: csm_mtl_item_locations_acc mil_acc,

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
133: AND msl.organization_id = msi_acc.organization_id