DBA Data[Home] [Help]

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 93: csm_mtl_item_locations_acc mil_acc,

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,
94: mtl_secondary_locators msl
95: WHERE msl.inventory_item_id = msi_acc.inventory_item_id
96: AND msl.organization_id = msi_acc.organization_id
97: AND msl.secondary_locator = mil_acc.inventory_location_id