DBA Data[Home] [Help]

APPS.JAI_PO_TAX_PKG dependencies on JAI_RETRO_LINE_CHANGES

Line 1528: Jai_Retro_Line_Changes jrlc

1524: WHERE jrtc.tax_id = rec_retro.tax_id
1525: AND jrtc.line_change_id = (SELECT
1526: jrlc.line_change_id
1527: FROM
1528: Jai_Retro_Line_Changes jrlc
1529: WHERE jrlc.doc_header_id = p_header_id
1530: AND jrlc.doc_line_id = P_line_id
1531: AND jrlc.doc_type = 'RECEIPT'
1532: AND jrlc.doc_version_number = (SELECT

Line 1535: Jai_Retro_Line_Changes jrlc1

1531: AND jrlc.doc_type = 'RECEIPT'
1532: AND jrlc.doc_version_number = (SELECT
1533: MAX(jrlc1.doc_version_number)
1534: FROM
1535: Jai_Retro_Line_Changes jrlc1
1536: WHERE jrlc1.doc_header_id = p_header_id
1537: AND jrlc1.doc_line_id = P_line_id
1538: AND jrlc1.doc_type = 'RECEIPT'
1539: )

Line 1552: Jai_Retro_Line_Changes jrlc

1548: WHERE jrtc.tax_id = rec_retro.tax_id
1549: AND jrtc.line_change_id = (SELECT
1550: line_change_id
1551: FROM
1552: Jai_Retro_Line_Changes jrlc
1553: WHERE jrlc.line_location_id = p_line_loc_id
1554: AND jrlc.doc_line_id = p_line_id
1555: AND jrlc.doc_type IN ( 'RELEASE'
1556: , 'STANDARD PO'

Line 1561: Jai_Retro_Line_Changes jrlc1

1557: )
1558: AND jrlc.doc_version_number = (SELECT
1559: MAX(jrlc1.doc_version_number)
1560: FROM
1561: Jai_Retro_Line_Changes jrlc1
1562: WHERE jrlc1.line_location_id = p_line_loc_id
1563: AND jrlc1.doc_line_id = p_line_id
1564: AND jrlc1.doc_type IN ( 'RELEASE'
1565: , 'STANDARD PO'

Line 4443: Jai_Retro_Line_Changes jrlc

4439: WHERE jrtc.tax_id = rec.tax_id
4440: AND jrtc.line_change_id = (SELECT
4441: line_change_id
4442: FROM
4443: Jai_Retro_Line_Changes jrlc
4444: WHERE jrlc.line_location_id = p_line_location_id
4445: AND jrlc.doc_type IN ( 'RELEASE'
4446: , 'RECEIPT'
4447: , 'STANDARD PO'

Line 4452: Jai_Retro_Line_Changes jrlc1

4448: )
4449: AND jrlc.doc_version_number = (SELECT
4450: MAX(jrlc1.doc_version_number)
4451: FROM
4452: Jai_Retro_Line_Changes jrlc1
4453: WHERE jrlc1.line_location_id = p_line_location_id
4454: AND jrlc1.doc_type IN ( 'RELEASE'
4455: , 'RECEIPT'
4456: , 'STANDARD PO'