DBA Data[Home] [Help]

APPS.JAI_PO_TAX_PKG dependencies on JAI_RETRO_LINE_CHANGES

Line 2221: Jai_Retro_Line_Changes jrlc

2217: WHERE jrtc.tax_id = rec_retro.tax_id
2218: AND jrtc.line_change_id = (SELECT
2219: jrlc.line_change_id
2220: FROM
2221: Jai_Retro_Line_Changes jrlc
2222: WHERE jrlc.doc_header_id = p_header_id
2223: AND jrlc.doc_line_id = P_line_id
2224: AND jrlc.doc_type = 'RECEIPT'
2225: AND jrlc.doc_version_number = (SELECT

Line 2228: Jai_Retro_Line_Changes jrlc1

2224: AND jrlc.doc_type = 'RECEIPT'
2225: AND jrlc.doc_version_number = (SELECT
2226: MAX(jrlc1.doc_version_number)
2227: FROM
2228: Jai_Retro_Line_Changes jrlc1
2229: WHERE jrlc1.doc_header_id = p_header_id
2230: AND jrlc1.doc_line_id = P_line_id
2231: AND jrlc1.doc_type = 'RECEIPT'
2232: )

Line 2245: Jai_Retro_Line_Changes jrlc

2241: WHERE jrtc.tax_id = rec_retro.tax_id
2242: AND jrtc.line_change_id = (SELECT
2243: line_change_id
2244: FROM
2245: Jai_Retro_Line_Changes jrlc
2246: WHERE jrlc.line_location_id = p_line_loc_id
2247: AND jrlc.doc_line_id = p_line_id
2248: AND jrlc.doc_type IN ( 'RELEASE'
2249: , 'STANDARD PO'

Line 2254: Jai_Retro_Line_Changes jrlc1

2250: )
2251: AND jrlc.doc_version_number = (SELECT
2252: MAX(jrlc1.doc_version_number)
2253: FROM
2254: Jai_Retro_Line_Changes jrlc1
2255: WHERE jrlc1.line_location_id = p_line_loc_id
2256: AND jrlc1.doc_line_id = p_line_id
2257: AND jrlc1.doc_type IN ( 'RELEASE'
2258: , 'STANDARD PO'

Line 5824: Jai_Retro_Line_Changes jrlc

5820: WHERE jrtc.tax_id = rec.tax_id
5821: AND jrtc.line_change_id = (SELECT
5822: line_change_id
5823: FROM
5824: Jai_Retro_Line_Changes jrlc
5825: WHERE jrlc.line_location_id = p_line_location_id
5826: AND jrlc.doc_type IN ( 'RELEASE'
5827: , 'RECEIPT'
5828: , 'STANDARD PO'

Line 5833: Jai_Retro_Line_Changes jrlc1

5829: )
5830: AND jrlc.doc_version_number = (SELECT
5831: MAX(jrlc1.doc_version_number)
5832: FROM
5833: Jai_Retro_Line_Changes jrlc1
5834: WHERE jrlc1.line_location_id = p_line_location_id
5835: AND jrlc1.doc_type IN ( 'RELEASE'
5836: , 'RECEIPT'
5837: , 'STANDARD PO'