APPS.INV_UI_ITEM_ATT_LOVS dependencies on MTL_PHYSICAL_ADJUSTMENTS

Line 862: FROM mtl_physical_adjustments

858: AND mpit.organization_id = p_organization_id
859: AND NVL(mpit.parent_lpn_id, -99999) = NVL(p_parent_lpn_id, -99999)
860: AND NVL(mpit.void_flag, 2) = 2
861: AND (mpit.adjustment_id IN (SELECT adjustment_id
862: FROM mtl_physical_adjustments
863: WHERE physical_inventory_id = p_physical_inventory_id
864: AND organization_id = p_organization_id
865: AND approval_status IS NULL) OR mpit.adjustment_id IS NULL)-- Bug#9772069
866: ORDER BY LPAD(msn.serial_number, 20);

Line 1002: FROM mtl_physical_adjustments

998: AND msn.serial_number > p_from_serial_number
999: AND NVL(mpit.parent_lpn_id, -99999) = NVL(p_parent_lpn_id, -99999)
1000: AND NVL(mpit.void_flag, 2) = 2
1001: AND (mpit.adjustment_id IN (SELECT adjustment_id
1002: FROM mtl_physical_adjustments
1003: WHERE physical_inventory_id = p_physical_inventory_id
1004: AND organization_id = p_organization_id
1005: AND approval_status IS NULL) OR mpit.adjustment_id IS NULL) --Bug#9772069
1006: -- Bug# 2770853

Line 1106: FROM mtl_physical_adjustments

1102: AND NVL(mpit.locator_id, -99999) = NVL(p_locator_id, -99999)
1103: AND NVL(mpit.void_flag, 2) = 2
1104: AND mpit.tag_quantity IS NULL
1105: AND mpit.adjustment_id IN (SELECT adjustment_id
1106: FROM mtl_physical_adjustments
1107: WHERE physical_inventory_id = p_physical_inventory_id
1108: AND organization_id = p_organization_id
1109: AND approval_status IS NULL)
1110: AND msn.inventory_item_id = msik.inventory_item_id