DBA Data[Home] [Help]

APPS.CSM_MTL_SEC_LOCATORS_EVENT_PKG dependencies on CSM_USER_INVENTORY_ORG

Line 78: csm_user_inventory_org uorg

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

Line 131: csm_user_inventory_org uorg

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