DBA Data[Home] [Help]

APPS.JAI_AP_ST_REVERSE_PROCESS dependencies on STANDARD

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

3314: WHERE jrlc.line_location_id = p_line_location_id
3315: AND jrlc.line_change_id = jrl.line_change_id
3316: AND jrlc.doc_version_number = (SELECT max(doc_version_number)
3317: FROM jai_retro_line_changes
3318: WHERE doc_type IN ('STANDARD PO', 'RELEASE')
3319: AND doc_line_id = jrlc.doc_line_id
3320: )
3321: AND jrlc.doc_type IN ('STANDARD PO', 'RELEASE')
3322: AND jrl.tax_id = jcta.tax_id

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

3317: FROM jai_retro_line_changes
3318: WHERE doc_type IN ('STANDARD PO', 'RELEASE')
3319: AND doc_line_id = jrlc.doc_line_id
3320: )
3321: AND jrlc.doc_type IN ('STANDARD PO', 'RELEASE')
3322: AND jrl.tax_id = jcta.tax_id
3323: AND NVL(jrlc.vendor_id, -1) = vend_id
3324: AND p_source = 'PPA'
3325: AND NVL(upper(jrl.tax_type),'TDS') NOT IN ( jai_constants.tax_type_tds