APPS.INV_UI_ITEM_ATT_LOVS dependencies on INV_PROJECT

Line 637: , inv_project.get_locsegs(a.current_locator_id, p_current_organization_id)

633: , a.lot_number
634: , b.expiration_date
635: , a.current_status
636: , mms.status_code
637: , inv_project.get_locsegs(a.current_locator_id, p_current_organization_id)
638: , inv_project.get_project_id
639: , inv_project.get_project_number
640: , inv_project.get_task_id
641: , inv_project.get_task_number

Line 638: , inv_project.get_project_id

634: , b.expiration_date
635: , a.current_status
636: , mms.status_code
637: , inv_project.get_locsegs(a.current_locator_id, p_current_organization_id)
638: , inv_project.get_project_id
639: , inv_project.get_project_number
640: , inv_project.get_task_id
641: , inv_project.get_task_number
642: FROM mtl_serial_numbers a, mtl_lot_numbers b, mtl_material_statuses_tl mms

Line 639: , inv_project.get_project_number

635: , a.current_status
636: , mms.status_code
637: , inv_project.get_locsegs(a.current_locator_id, p_current_organization_id)
638: , inv_project.get_project_id
639: , inv_project.get_project_number
640: , inv_project.get_task_id
641: , inv_project.get_task_number
642: FROM mtl_serial_numbers a, mtl_lot_numbers b, mtl_material_statuses_tl mms
643: WHERE a.current_organization_id = p_current_organization_id

Line 640: , inv_project.get_task_id

636: , mms.status_code
637: , inv_project.get_locsegs(a.current_locator_id, p_current_organization_id)
638: , inv_project.get_project_id
639: , inv_project.get_project_number
640: , inv_project.get_task_id
641: , inv_project.get_task_number
642: FROM mtl_serial_numbers a, mtl_lot_numbers b, mtl_material_statuses_tl mms
643: WHERE a.current_organization_id = p_current_organization_id
644: AND NVL(a.lpn_id, -1) = NVL(p_lpn_id, -1)

Line 641: , inv_project.get_task_number

637: , inv_project.get_locsegs(a.current_locator_id, p_current_organization_id)
638: , inv_project.get_project_id
639: , inv_project.get_project_number
640: , inv_project.get_task_id
641: , inv_project.get_task_number
642: FROM mtl_serial_numbers a, mtl_lot_numbers b, mtl_material_statuses_tl mms
643: WHERE a.current_organization_id = p_current_organization_id
644: AND NVL(a.lpn_id, -1) = NVL(p_lpn_id, -1)
645: AND a.inventory_item_id = p_inventory_item_id

Line 689: , inv_project.get_locsegs(a.current_locator_id, p_current_organization_id)

685: , a.lot_number
686: , b.expiration_date
687: , a.current_status
688: , mms.status_code
689: , inv_project.get_locsegs(a.current_locator_id, p_current_organization_id)
690: , inv_project.get_project_id
691: , inv_project.get_project_number
692: , inv_project.get_task_id
693: , inv_project.get_task_number

Line 690: , inv_project.get_project_id

686: , b.expiration_date
687: , a.current_status
688: , mms.status_code
689: , inv_project.get_locsegs(a.current_locator_id, p_current_organization_id)
690: , inv_project.get_project_id
691: , inv_project.get_project_number
692: , inv_project.get_task_id
693: , inv_project.get_task_number
694: FROM mtl_serial_numbers a, mtl_lot_numbers b, mtl_material_statuses_tl mms

Line 691: , inv_project.get_project_number

687: , a.current_status
688: , mms.status_code
689: , inv_project.get_locsegs(a.current_locator_id, p_current_organization_id)
690: , inv_project.get_project_id
691: , inv_project.get_project_number
692: , inv_project.get_task_id
693: , inv_project.get_task_number
694: FROM mtl_serial_numbers a, mtl_lot_numbers b, mtl_material_statuses_tl mms
695: WHERE a.current_organization_id = p_current_organization_id

Line 692: , inv_project.get_task_id

688: , mms.status_code
689: , inv_project.get_locsegs(a.current_locator_id, p_current_organization_id)
690: , inv_project.get_project_id
691: , inv_project.get_project_number
692: , inv_project.get_task_id
693: , inv_project.get_task_number
694: FROM mtl_serial_numbers a, mtl_lot_numbers b, mtl_material_statuses_tl mms
695: WHERE a.current_organization_id = p_current_organization_id
696: AND NVL(a.lpn_id, -1) = NVL(p_lpn_id, -1)

Line 693: , inv_project.get_task_number

689: , inv_project.get_locsegs(a.current_locator_id, p_current_organization_id)
690: , inv_project.get_project_id
691: , inv_project.get_project_number
692: , inv_project.get_task_id
693: , inv_project.get_task_number
694: FROM mtl_serial_numbers a, mtl_lot_numbers b, mtl_material_statuses_tl mms
695: WHERE a.current_organization_id = p_current_organization_id
696: AND NVL(a.lpn_id, -1) = NVL(p_lpn_id, -1)
697: AND a.inventory_item_id = p_inventory_item_id

Line 2790: inv_project.get_locsegs(msn.current_locator_id, p_current_organization_id)

2786: , msn.current_subinventory_code
2787: , msn.current_locator_id
2788: , --I Development Bug 2634570
2789: --milv.concatenated_segments,
2790: inv_project.get_locsegs(msn.current_locator_id, p_current_organization_id)
2791: , msn.inventory_item_id
2792: , msiv.concatenated_segments
2793: , msiv.description
2794: , msn.revision

Line 2803: inv_project.get_project_id

2799: , msi.asset_inventory
2800: , msiv.location_control_code
2801: , msiv.primary_uom_code
2802: , --I Development Bug 2634570
2803: inv_project.get_project_id
2804: , inv_project.get_project_number
2805: , inv_project.get_task_id
2806: , inv_project.get_task_number
2807: FROM mtl_serial_numbers msn

Line 2804: , inv_project.get_project_number

2800: , msiv.location_control_code
2801: , msiv.primary_uom_code
2802: , --I Development Bug 2634570
2803: inv_project.get_project_id
2804: , inv_project.get_project_number
2805: , inv_project.get_task_id
2806: , inv_project.get_task_number
2807: FROM mtl_serial_numbers msn
2808: , mtl_system_items_vl msiv

Line 2805: , inv_project.get_task_id

2801: , msiv.primary_uom_code
2802: , --I Development Bug 2634570
2803: inv_project.get_project_id
2804: , inv_project.get_project_number
2805: , inv_project.get_task_id
2806: , inv_project.get_task_number
2807: FROM mtl_serial_numbers msn
2808: , mtl_system_items_vl msiv
2809: , mtl_item_locations_kfv milv

Line 2806: , inv_project.get_task_number

2802: , --I Development Bug 2634570
2803: inv_project.get_project_id
2804: , inv_project.get_project_number
2805: , inv_project.get_task_id
2806: , inv_project.get_task_number
2807: FROM mtl_serial_numbers msn
2808: , mtl_system_items_vl msiv
2809: , mtl_item_locations_kfv milv
2810: , mtl_secondary_inventories msi