APPS.INV_UI_ITEM_LOVS dependencies on MTL_PHYSICAL_INVENTORY_TAGS

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

2228: NVL(msik.SECONDARY_DEFAULT_IND,''),
2229: NVL(msik.TRACKING_QUANTITY_IND,'P'),
2230: NVL(msik.DUAL_UOM_DEVIATION_HIGH,0),
2231: NVL(msik.DUAL_UOM_DEVIATION_LOW,0)
2232: FROM mtl_system_items_vl msik, mtl_physical_inventory_tags mpit /* Bug 5581528 */
2233: WHERE msik.organization_id = p_organization_id
2234: AND msik.concatenated_segments LIKE (p_concatenated_segments)
2235: AND msik.inventory_item_id = mpit.inventory_item_id
2236: AND mpit.physical_inventory_id = p_physical_inventory_id

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

2297: NVL(msik.SECONDARY_DEFAULT_IND,''),
2298: NVL(msik.TRACKING_QUANTITY_IND,'P'),
2299: NVL(msik.DUAL_UOM_DEVIATION_HIGH,0),
2300: NVL(msik.DUAL_UOM_DEVIATION_LOW,0)
2301: FROM mtl_system_items_vl msik, mtl_physical_inventory_tags mpit, mtl_cross_references mcr /* Bug 5581528 */
2302: WHERE msik.organization_id = p_organization_id
2303: AND msik.inventory_item_id = mpit.inventory_item_id
2304: AND mpit.physical_inventory_id = p_physical_inventory_id
2305: AND mpit.organization_id = p_organization_id

Line 2360: FROM mtl_item_revisions mir, mtl_physical_inventory_tags mpit

2356: OPEN x_revs FOR
2357: SELECT UNIQUE mir.revision
2358: , mir.effectivity_date
2359: , NVL(mir.description, '')
2360: FROM mtl_item_revisions mir, mtl_physical_inventory_tags mpit
2361: WHERE mir.organization_id = p_organization_id
2362: AND mir.inventory_item_id = p_inventory_item_id
2363: AND mir.revision LIKE (p_revision)
2364: AND mir.inventory_item_id = mpit.inventory_item_id