APPS.INV_UI_ITEM_LOVS dependencies on MTL_PHYSICAL_INVENTORY_TAGS

Line 2370: FROM mtl_system_items_vl msik, mtl_physical_inventory_tags mpit /* Bug 5581528 */

2366: NVL(msik.SECONDARY_DEFAULT_IND,''),
2367: NVL(msik.TRACKING_QUANTITY_IND,'P'),
2368: NVL(msik.DUAL_UOM_DEVIATION_HIGH,0),
2369: NVL(msik.DUAL_UOM_DEVIATION_LOW,0)
2370: FROM mtl_system_items_vl msik, mtl_physical_inventory_tags mpit /* Bug 5581528 */
2371: WHERE msik.organization_id = p_organization_id
2372: AND msik.concatenated_segments LIKE (p_concatenated_segments||l_append)
2373: AND msik.inventory_item_id = mpit.inventory_item_id
2374: AND mpit.physical_inventory_id = p_physical_inventory_id

Line 2442: FROM mtl_system_items_vl msik, mtl_physical_inventory_tags mpit, mtl_cross_references mcr /* Bug 5581528 */

2438: NVL(msik.SECONDARY_DEFAULT_IND,''),
2439: NVL(msik.TRACKING_QUANTITY_IND,'P'),
2440: NVL(msik.DUAL_UOM_DEVIATION_HIGH,0),
2441: NVL(msik.DUAL_UOM_DEVIATION_LOW,0)
2442: FROM mtl_system_items_vl msik, mtl_physical_inventory_tags mpit, mtl_cross_references mcr /* Bug 5581528 */
2443: WHERE msik.organization_id = p_organization_id
2444: AND msik.inventory_item_id = mpit.inventory_item_id
2445: AND mpit.physical_inventory_id = p_physical_inventory_id
2446: AND mpit.organization_id = p_organization_id

Line 2501: FROM mtl_item_revisions mir, mtl_physical_inventory_tags mpit

2497: OPEN x_revs FOR
2498: SELECT UNIQUE mir.revision
2499: , mir.effectivity_date
2500: , NVL(mir.description, '')
2501: FROM mtl_item_revisions mir, mtl_physical_inventory_tags mpit
2502: WHERE mir.organization_id = p_organization_id
2503: AND mir.inventory_item_id = p_inventory_item_id
2504: AND mir.revision LIKE (p_revision)
2505: AND mir.inventory_item_id = mpit.inventory_item_id