DBA Data[Home] [Help]

APPS.INV_UI_ITEM_SUB_LOC_LOVS dependencies on MTL_PHYSICAL_ADJUSTMENTS

Line 2302: FROM mtl_physical_adjustments

2298: AND NVL(mil.task_id, -1) = NVL(p_task_id, -1)
2299: --For bug number 4885951
2300: AND NVL(mil.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
2301: AND (mpit.adjustment_id IN (SELECT adjustment_id
2302: FROM mtl_physical_adjustments
2303: WHERE physical_inventory_id = p_physical_inventory_id
2304: AND organization_id = p_organization_id
2305: AND approval_status IS NULL)
2306: OR mpit.adjustment_id is NULL); --For bug#9772069

Line 2376: FROM mtl_physical_adjustments

2372: AND NVL(mil.task_id, -1) = NVL(p_task_id, -1)
2373: --For bug number 4885951
2374: AND NVL(mil.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
2375: AND (mpit.adjustment_id IN (SELECT adjustment_id
2376: FROM mtl_physical_adjustments
2377: WHERE physical_inventory_id = p_physical_inventory_id
2378: AND organization_id = p_organization_id
2379: AND approval_status IS NULL)
2380: OR mpit.adjustment_id is NULL); --For bug#9772069