APPS.AHL_PRD_MRSHL_PVT dependencies on INV_PROJECT

Line 243: decode(msi.segment19, null, mil.concatenated_segments, INV_PROJECT.GET_LOCSEGS(mil.concatenated_segments) ||

239: p_locator_id NUMBER) IS
240: select msn.serial_number , msn.lot_number ,msn.revision,
241: msn.current_subinventory_code,msn.current_locator_id,
242:
243: decode(msi.segment19, null, mil.concatenated_segments, INV_PROJECT.GET_LOCSEGS(mil.concatenated_segments) ||
244: fnd_flex_ext.get_delimiter('INV', 'MTLL', 101) || INV_ProjectLocator_PUB.get_project_number(msi.segment19) ||
245: fnd_flex_ext.get_delimiter('INV', 'MTLL', 101) || INV_ProjectLocator_PUB.get_task_number(msi.segment20))
246: locator_segments
247: from mtl_serial_numbers msn,

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

240: select msn.serial_number , msn.lot_number ,msn.revision,
241: msn.current_subinventory_code,msn.current_locator_id,
242:
243: decode(msi.segment19, null, mil.concatenated_segments, INV_PROJECT.GET_LOCSEGS(mil.concatenated_segments) ||
244: fnd_flex_ext.get_delimiter('INV', 'MTLL', 101) || INV_ProjectLocator_PUB.get_project_number(msi.segment19) ||
245: fnd_flex_ext.get_delimiter('INV', 'MTLL', 101) || INV_ProjectLocator_PUB.get_task_number(msi.segment20))
246: locator_segments
247: from mtl_serial_numbers msn,
248: mtl_system_items_kfv mkfv,

Line 245: fnd_flex_ext.get_delimiter('INV', 'MTLL', 101) || INV_ProjectLocator_PUB.get_task_number(msi.segment20))

241: msn.current_subinventory_code,msn.current_locator_id,
242:
243: decode(msi.segment19, null, mil.concatenated_segments, INV_PROJECT.GET_LOCSEGS(mil.concatenated_segments) ||
244: fnd_flex_ext.get_delimiter('INV', 'MTLL', 101) || INV_ProjectLocator_PUB.get_project_number(msi.segment19) ||
245: fnd_flex_ext.get_delimiter('INV', 'MTLL', 101) || INV_ProjectLocator_PUB.get_task_number(msi.segment20))
246: locator_segments
247: from mtl_serial_numbers msn,
248: mtl_system_items_kfv mkfv,
249: mtl_item_locations_kfv mil,