DBA Data[Home] [Help]

APPS.PO_VAL_SHIPMENTS2 dependencies on ZX_INPUT_CLASSIFICATIONS_V

Line 1622: FROM ZX_INPUT_CLASSIFICATIONS_V zicv

1618: FROM DUAL
1619: WHERE p_tax_name_tbl(i) IS NOT NULL
1620: AND p_tax_code_id_tbl(i) IS NULL
1621: AND NOT EXISTS(SELECT 'Y'
1622: FROM ZX_INPUT_CLASSIFICATIONS_V zicv
1623: WHERE zicv.lookup_code = p_tax_name_tbl(i)
1624: AND zicv.org_id in (p_operating_unit, -99)
1625: AND zicv.enabled_flag = 'Y'
1626: AND NVL(p_need_by_date_tbl(i),SYSDATE) BETWEEN