APPS.INV_UI_ITEM_ATT_LOVS dependencies on INV_PROJECT

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

575: , a.lot_number
576: , b.expiration_date
577: , a.current_status
578: , mms.status_code
579: , inv_project.get_locsegs(a.current_locator_id, p_current_organization_id)
580: , inv_project.get_project_id
581: , inv_project.get_project_number
582: , inv_project.get_task_id
583: , inv_project.get_task_number

Line 580: , inv_project.get_project_id

576: , b.expiration_date
577: , a.current_status
578: , mms.status_code
579: , inv_project.get_locsegs(a.current_locator_id, p_current_organization_id)
580: , inv_project.get_project_id
581: , inv_project.get_project_number
582: , inv_project.get_task_id
583: , inv_project.get_task_number
584: FROM mtl_serial_numbers a, mtl_lot_numbers b, mtl_material_statuses_tl mms

Line 581: , inv_project.get_project_number

577: , a.current_status
578: , mms.status_code
579: , inv_project.get_locsegs(a.current_locator_id, p_current_organization_id)
580: , inv_project.get_project_id
581: , inv_project.get_project_number
582: , inv_project.get_task_id
583: , inv_project.get_task_number
584: FROM mtl_serial_numbers a, mtl_lot_numbers b, mtl_material_statuses_tl mms
585: WHERE a.current_organization_id = p_current_organization_id

Line 582: , inv_project.get_task_id

578: , mms.status_code
579: , inv_project.get_locsegs(a.current_locator_id, p_current_organization_id)
580: , inv_project.get_project_id
581: , inv_project.get_project_number
582: , inv_project.get_task_id
583: , inv_project.get_task_number
584: FROM mtl_serial_numbers a, mtl_lot_numbers b, mtl_material_statuses_tl mms
585: WHERE a.current_organization_id = p_current_organization_id
586: AND NVL(a.lpn_id, -1) = NVL(p_lpn_id, -1)

Line 583: , inv_project.get_task_number

579: , inv_project.get_locsegs(a.current_locator_id, p_current_organization_id)
580: , inv_project.get_project_id
581: , inv_project.get_project_number
582: , inv_project.get_task_id
583: , inv_project.get_task_number
584: FROM mtl_serial_numbers a, mtl_lot_numbers b, mtl_material_statuses_tl mms
585: WHERE a.current_organization_id = p_current_organization_id
586: AND NVL(a.lpn_id, -1) = NVL(p_lpn_id, -1)
587: AND a.inventory_item_id = p_inventory_item_id

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

627: , a.lot_number
628: , b.expiration_date
629: , a.current_status
630: , mms.status_code
631: , inv_project.get_locsegs(a.current_locator_id, p_current_organization_id)
632: , inv_project.get_project_id
633: , inv_project.get_project_number
634: , inv_project.get_task_id
635: , inv_project.get_task_number

Line 632: , inv_project.get_project_id

628: , b.expiration_date
629: , a.current_status
630: , mms.status_code
631: , inv_project.get_locsegs(a.current_locator_id, p_current_organization_id)
632: , inv_project.get_project_id
633: , inv_project.get_project_number
634: , inv_project.get_task_id
635: , inv_project.get_task_number
636: FROM mtl_serial_numbers a, mtl_lot_numbers b, mtl_material_statuses_tl mms

Line 633: , inv_project.get_project_number

629: , a.current_status
630: , mms.status_code
631: , inv_project.get_locsegs(a.current_locator_id, p_current_organization_id)
632: , inv_project.get_project_id
633: , inv_project.get_project_number
634: , inv_project.get_task_id
635: , inv_project.get_task_number
636: FROM mtl_serial_numbers a, mtl_lot_numbers b, mtl_material_statuses_tl mms
637: WHERE a.current_organization_id = p_current_organization_id

Line 634: , inv_project.get_task_id

630: , mms.status_code
631: , inv_project.get_locsegs(a.current_locator_id, p_current_organization_id)
632: , inv_project.get_project_id
633: , inv_project.get_project_number
634: , inv_project.get_task_id
635: , inv_project.get_task_number
636: FROM mtl_serial_numbers a, mtl_lot_numbers b, mtl_material_statuses_tl mms
637: WHERE a.current_organization_id = p_current_organization_id
638: AND NVL(a.lpn_id, -1) = NVL(p_lpn_id, -1)

Line 635: , inv_project.get_task_number

631: , inv_project.get_locsegs(a.current_locator_id, p_current_organization_id)
632: , inv_project.get_project_id
633: , inv_project.get_project_number
634: , inv_project.get_task_id
635: , inv_project.get_task_number
636: FROM mtl_serial_numbers a, mtl_lot_numbers b, mtl_material_statuses_tl mms
637: WHERE a.current_organization_id = p_current_organization_id
638: AND NVL(a.lpn_id, -1) = NVL(p_lpn_id, -1)
639: AND a.inventory_item_id = p_inventory_item_id

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

2699: , msn.current_subinventory_code
2700: , msn.current_locator_id
2701: , --I Development Bug 2634570
2702: --milv.concatenated_segments,
2703: inv_project.get_locsegs(msn.current_locator_id, p_current_organization_id)
2704: , msn.inventory_item_id
2705: , msiv.concatenated_segments
2706: , msiv.description
2707: , msn.revision

Line 2716: inv_project.get_project_id

2712: , msi.asset_inventory
2713: , msiv.location_control_code
2714: , msiv.primary_uom_code
2715: , --I Development Bug 2634570
2716: inv_project.get_project_id
2717: , inv_project.get_project_number
2718: , inv_project.get_task_id
2719: , inv_project.get_task_number
2720: FROM mtl_serial_numbers msn

Line 2717: , inv_project.get_project_number

2713: , msiv.location_control_code
2714: , msiv.primary_uom_code
2715: , --I Development Bug 2634570
2716: inv_project.get_project_id
2717: , inv_project.get_project_number
2718: , inv_project.get_task_id
2719: , inv_project.get_task_number
2720: FROM mtl_serial_numbers msn
2721: , mtl_system_items_vl msiv

Line 2718: , inv_project.get_task_id

2714: , msiv.primary_uom_code
2715: , --I Development Bug 2634570
2716: inv_project.get_project_id
2717: , inv_project.get_project_number
2718: , inv_project.get_task_id
2719: , inv_project.get_task_number
2720: FROM mtl_serial_numbers msn
2721: , mtl_system_items_vl msiv
2722: , mtl_item_locations_kfv milv

Line 2719: , inv_project.get_task_number

2715: , --I Development Bug 2634570
2716: inv_project.get_project_id
2717: , inv_project.get_project_number
2718: , inv_project.get_task_id
2719: , inv_project.get_task_number
2720: FROM mtl_serial_numbers msn
2721: , mtl_system_items_vl msiv
2722: , mtl_item_locations_kfv milv
2723: , mtl_secondary_inventories msi