eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_UI_ITEM_ATT_LOVS dependencies on MTL_PHYSICAL_ADJUSTMENTS

Line 799: FROM mtl_physical_adjustments

795: AND mpit.organization_id = p_organization_id
796: AND NVL(mpit.parent_lpn_id, -99999) = NVL(p_parent_lpn_id, -99999)
797: AND NVL(mpit.void_flag, 2) = 2
798: AND mpit.adjustment_id IN (SELECT adjustment_id
799: FROM mtl_physical_adjustments
800: WHERE physical_inventory_id = p_physical_inventory_id
801: AND organization_id = p_organization_id
802: AND approval_status IS NULL)
803: ORDER BY LPAD(msn.serial_number, 20);

Line 939: FROM mtl_physical_adjustments

935: AND msn.serial_number > p_from_serial_number
936: AND NVL(mpit.parent_lpn_id, -99999) = NVL(p_parent_lpn_id, -99999)
937: AND NVL(mpit.void_flag, 2) = 2
938: AND mpit.adjustment_id IN (SELECT adjustment_id
939: FROM mtl_physical_adjustments
940: WHERE physical_inventory_id = p_physical_inventory_id
941: AND organization_id = p_organization_id
942: AND approval_status IS NULL)
943: -- Bug# 2770853

Line 1043: FROM mtl_physical_adjustments

1039: AND NVL(mpit.locator_id, -99999) = NVL(p_locator_id, -99999)
1040: AND NVL(mpit.void_flag, 2) = 2
1041: AND mpit.tag_quantity IS NULL
1042: AND mpit.adjustment_id IN (SELECT adjustment_id
1043: FROM mtl_physical_adjustments
1044: WHERE physical_inventory_id = p_physical_inventory_id
1045: AND organization_id = p_organization_id
1046: AND approval_status IS NULL)
1047: AND msn.inventory_item_id = msik.inventory_item_id