DBA Data[Home] [Help]

APPS.JAI_CMN_TAX_DEFAULTATION_PKG dependencies on JAI_RETRO_LINE_CHANGES

Line 3032: Jai_Retro_Line_Changes jrlc

3028: WHERE jrtc.tax_id = rec.tax_id
3029: AND jrtc.line_change_id = (SELECT
3030: line_change_id
3031: FROM
3032: Jai_Retro_Line_Changes jrlc
3033: WHERE jrlc.line_location_id = lv_line_loc_id
3034: AND jrlc.doc_type IN ( 'RELEASE'
3035: , 'RECEIPT'
3036: , 'STANDARD PO'

Line 3041: Jai_Retro_Line_Changes jrlc1

3037: )
3038: AND jrlc.doc_version_number = (SELECT
3039: MAX(jrlc1.doc_version_number)
3040: FROM
3041: Jai_Retro_Line_Changes jrlc1
3042: WHERE jrlc1.line_location_id = lv_line_loc_id
3043: AND jrlc1.doc_type IN ( 'RELEASE'
3044: , 'RECEIPT'
3045: , 'STANDARD PO'