DBA Data[Home] [Help]

APPS.JAI_AP_MATCH_TAX_PKG dependencies on STANDARD

Line 898: WHERE doc_type IN ('STANDARD PO', 'RELEASE')

894: WHERE jrlc.line_location_id = p_line_location_id
895: AND jrlc.line_change_id = jrl.line_change_id
896: AND jrlc.doc_version_number = (SELECT max(doc_version_number)
897: FROM jai_retro_line_changes
898: WHERE doc_type IN ('STANDARD PO', 'RELEASE')
899: AND doc_line_id = jrlc.doc_line_id
900: )
901: AND jrlc.doc_type IN ('STANDARD PO', 'RELEASE')
902: AND jrl.tax_id = jcta.tax_id

Line 901: AND jrlc.doc_type IN ('STANDARD PO', 'RELEASE')

897: FROM jai_retro_line_changes
898: WHERE doc_type IN ('STANDARD PO', 'RELEASE')
899: AND doc_line_id = jrlc.doc_line_id
900: )
901: AND jrlc.doc_type IN ('STANDARD PO', 'RELEASE')
902: AND jrl.tax_id = jcta.tax_id
903: AND NVL(jrlc.vendor_id, -1) = vend_id
904: AND p_source = 'PPA'
905: AND NVL(upper(jrl.tax_type),'TDS') NOT IN ( jai_constants.tax_type_tds