DBA Data[Home] [Help]

APPS.JAI_AP_MATCH_TAX_PKG dependencies on STANDARD

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

643: WHERE jrlc.line_location_id = p_line_location_id
644: AND jrlc.line_change_id = jrl.line_change_id
645: AND jrlc.doc_version_number = (SELECT max(doc_version_number)
646: FROM jai_retro_line_changes
647: WHERE doc_type IN ('STANDARD PO', 'RELEASE')
648: AND doc_line_id = jrlc.doc_line_id
649: )
650: AND jrlc.doc_type IN ('STANDARD PO', 'RELEASE')
651: AND jrl.tax_id = jcta.tax_id

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

646: FROM jai_retro_line_changes
647: WHERE doc_type IN ('STANDARD PO', 'RELEASE')
648: AND doc_line_id = jrlc.doc_line_id
649: )
650: AND jrlc.doc_type IN ('STANDARD PO', 'RELEASE')
651: AND jrl.tax_id = jcta.tax_id
652: AND NVL(jrlc.vendor_id, -1) = vend_id
653: AND p_source = 'PPA'
654: AND NVL(upper(jrl.tax_type),'TDS') NOT IN ( jai_constants.tax_type_tds