DBA Data[Home] [Help]

APPS.INV_UI_ITEM_SUB_LOC_LOVS dependencies on MTL_PHYSICAL_ADJUSTMENTS

Line 1927: FROM mtl_physical_adjustments

1923: AND NVL(mil.task_id, -1) = NVL(p_task_id, -1)
1924: --For bug number 4885951
1925: AND NVL(mil.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
1926: AND mpit.adjustment_id IN (SELECT adjustment_id
1927: FROM mtl_physical_adjustments
1928: WHERE physical_inventory_id = p_physical_inventory_id
1929: AND organization_id = p_organization_id
1930: AND approval_status IS NULL);
1931: ELSE

Line 2000: FROM mtl_physical_adjustments

1996: AND NVL(mil.task_id, -1) = NVL(p_task_id, -1)
1997: --For bug number 4885951
1998: AND NVL(mil.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
1999: AND mpit.adjustment_id IN (SELECT adjustment_id
2000: FROM mtl_physical_adjustments
2001: WHERE physical_inventory_id = p_physical_inventory_id
2002: AND organization_id = p_organization_id
2003: AND approval_status IS NULL);
2004: ELSE