APPS.JAI_AP_ST_REVERSE_PROCESS dependencies on JAI_RETRO_LINE_CHANGES

Line 3312: , jai_retro_line_changes jrlc

3308: ,nvl(jcta.vat_flag,'N') VAT_FLAG
3309: ,nvl(jcta.adhoc_flag,'N') adhoc_flag
3310: FROM
3311: jai_retro_tax_changes jrl
3312: , jai_retro_line_changes jrlc
3313: , jai_cmn_taxes_all jcta
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)

Line 3317: FROM jai_retro_line_changes

3313: , jai_cmn_taxes_all jcta
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')

Line 3503: , jai_retro_line_changes jrlc

3499: FROM
3500: jai_retro_tax_changes jrl
3501: , rcv_shipment_lines rsl
3502: , rcv_transactions rt
3503: , jai_retro_line_changes jrlc
3504: , jai_cmn_taxes_all jcta
3505: WHERE jrlc.doc_line_id = rsl.shipment_line_id
3506: AND jrlc.line_change_id = jrl.line_change_id
3507: AND jrlc.doc_version_number = (SELECT max(doc_version_number)

Line 3508: FROM jai_retro_line_changes

3504: , jai_cmn_taxes_all jcta
3505: WHERE jrlc.doc_line_id = rsl.shipment_line_id
3506: AND jrlc.line_change_id = jrl.line_change_id
3507: AND jrlc.doc_version_number = (SELECT max(doc_version_number)
3508: FROM jai_retro_line_changes
3509: WHERE doc_type = 'RECEIPT'
3510: AND doc_line_id = jrlc.doc_line_id
3511: )
3512: AND jrlc.doc_type = 'RECEIPT'