DBA Data[Home] [Help]

APPS.AHL_PRD_MRSHL_PVT dependencies on MTL_SERIAL_NUMBERS

Line 247: from mtl_serial_numbers msn,

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,
250: mtl_item_locations msi
251: WHERE msi.inventory_item_id = mkfv.inventory_item_id

Line 671: from mtl_serial_numbers msn,

667: p_inventory_item_id NUMBER,
668: p_subinventory_code VARCHAR2,
669: p_locator_id NUMBER) IS
670: select msn.serial_number , msn.lot_number ,msn.revision
671: from mtl_serial_numbers msn,
672: mtl_system_items_kfv mkfv,
673: mtl_item_locations_kfv mil
674: where msn.inventory_item_id = mkfv.inventory_item_id
675: and msn.current_organization_id=mkfv.organization_id