DBA Data[Home] [Help]

APPS.AHL_UTIL_UC_PKG dependencies on INV_PROJECTLOCATOR_PUB

Line 47: || INV_ProjectLocator_PUB.get_project_number(LOC.segment19) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)

43: CURSOR mtl_item_locations_csr(p_inventory_org_id IN NUMBER,
44: p_inventory_locator_id IN NUMBER) IS
45: --SELECT concatenated_segments
46: SELECT INV_PROJECT.GET_LOCSEGS(LOC.inventory_location_id, LOC.ORGANIZATION_ID) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
47: || INV_ProjectLocator_PUB.get_project_number(LOC.segment19) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
48: || INV_ProjectLocator_PUB.get_task_number(LOC.segment20)
49: --FROM mtl_item_locations_kfv
50: FROM mtl_item_locations LOC
51: WHERE inventory_location_id = p_inventory_locator_id

Line 48: || INV_ProjectLocator_PUB.get_task_number(LOC.segment20)

44: p_inventory_locator_id IN NUMBER) IS
45: --SELECT concatenated_segments
46: SELECT INV_PROJECT.GET_LOCSEGS(LOC.inventory_location_id, LOC.ORGANIZATION_ID) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
47: || INV_ProjectLocator_PUB.get_project_number(LOC.segment19) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
48: || INV_ProjectLocator_PUB.get_task_number(LOC.segment20)
49: --FROM mtl_item_locations_kfv
50: FROM mtl_item_locations LOC
51: WHERE inventory_location_id = p_inventory_locator_id
52: AND organization_id = p_inventory_org_id;