DBA Data[Home] [Help]

APPS.PO_VAL_SHIPMENTS2 dependencies on ZX_INPUT_CLASSIFICATIONS_V

Line 2045: FROM ZX_INPUT_CLASSIFICATIONS_V zicv

2041: FROM DUAL
2042: WHERE p_tax_name_tbl(i) IS NOT NULL
2043: AND p_tax_code_id_tbl(i) IS NULL
2044: AND NOT EXISTS(SELECT 'Y'
2045: FROM ZX_INPUT_CLASSIFICATIONS_V zicv
2046: WHERE zicv.lookup_code = p_tax_name_tbl(i)
2047: AND zicv.org_id in (p_operating_unit, -99)
2048: AND zicv.enabled_flag = 'Y'
2049: AND NVL(p_need_by_date_tbl(i),SYSDATE) BETWEEN