DBA Data[Home] [Help]

APPS.JA_JAINER1_XMLP_PKG dependencies on JAI_RCV_LINES

Line 1766: JAI_RCV_LINES JTL,

1762: AND exists (
1763: SELECT
1764: 1
1765: FROM
1766: JAI_RCV_LINES JTL,
1767: JAI_RCV_LINE_TAXES JRTL
1768: WHERE JTL.TRANSACTION_ID = JIRP.RECEIPT_REF
1769: AND JTL.SHIPMENT_LINE_ID = JRTL.SHIPMENT_LINE_ID
1770: AND JRTL.TAX_TYPE IN ( 'ADDITIONAL_CVD' , 'CVD' ) ) ) ) );

Line 1807: JAI_RCV_LINES JTL,

1803: AND exists (
1804: SELECT
1805: 1
1806: FROM
1807: JAI_RCV_LINES JTL,
1808: JAI_RCV_LINE_TAXES JRTL
1809: WHERE JTL.TRANSACTION_ID = JIRP.RECEIPT_REF
1810: AND JTL.SHIPMENT_LINE_ID = JRTL.SHIPMENT_LINE_ID
1811: AND JRTL.TAX_TYPE IN ( 'ADDITIONAL_CVD' , 'CVD' ) ) ) ) );

Line 1845: JAI_RCV_LINES JTL,

1841: AND exists (
1842: SELECT
1843: 1
1844: FROM
1845: JAI_RCV_LINES JTL,
1846: JAI_RCV_LINE_TAXES JRTL
1847: WHERE JTL.TRANSACTION_ID = JIRP.RECEIPT_REF
1848: AND JTL.SHIPMENT_LINE_ID = JRTL.SHIPMENT_LINE_ID
1849: AND JRTL.TAX_TYPE IN ( 'ADDITIONAL_CVD' , 'CVD' ) ) ) ) );

Line 1884: JAI_RCV_LINES JTL,

1880: AND exists (
1881: SELECT
1882: 1
1883: FROM
1884: JAI_RCV_LINES JTL,
1885: JAI_RCV_LINE_TAXES JRTL
1886: WHERE JTL.TRANSACTION_ID = JIRP.RECEIPT_REF
1887: AND JTL.SHIPMENT_LINE_ID = JRTL.SHIPMENT_LINE_ID
1888: AND JRTL.TAX_TYPE IN ( 'ADDITIONAL_CVD' , 'CVD' ) ) ) );

Line 1953: JAI_RCV_LINES JTL,

1949: AND exists (
1950: SELECT
1951: 1
1952: FROM
1953: JAI_RCV_LINES JTL,
1954: JAI_RCV_LINE_TAXES JRTL
1955: WHERE JTL.TRANSACTION_ID = JIRP.RECEIPT_REF
1956: AND JTL.SHIPMENT_LINE_ID = JRTL.SHIPMENT_LINE_ID
1957: AND JRTL.TAX_TYPE IN ( 'ADDITIONAL_CVD' , 'CVD' ) ) ) ) );

Line 1991: JAI_RCV_LINES JTL,

1987: AND exists (
1988: SELECT
1989: 1
1990: FROM
1991: JAI_RCV_LINES JTL,
1992: JAI_RCV_LINE_TAXES JRTL
1993: WHERE JTL.TRANSACTION_ID = JIRP.RECEIPT_REF
1994: AND JTL.SHIPMENT_LINE_ID = JRTL.SHIPMENT_LINE_ID
1995: AND JRTL.TAX_TYPE IN ( 'ADDITIONAL_CVD' , 'CVD' ) ) ) ) );

Line 2461: JAI_RCV_LINES JTL,

2457: AND exists (
2458: SELECT
2459: 1
2460: FROM
2461: JAI_RCV_LINES JTL,
2462: JAI_RCV_LINE_TAXES JRTL
2463: WHERE JTL.TRANSACTION_ID = JIRP.RECEIPT_REF
2464: AND JTL.SHIPMENT_LINE_ID = JRTL.SHIPMENT_LINE_ID
2465: AND JRTL.TAX_TYPE IN ( 'ADDITIONAL_CVD' , 'CVD' ) ) ) );