eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_ARXCCS_XMLP_PKG dependencies on RA_CUST_TRX_TYPES

Line 1203: RA_CUST_TRX_TYPES.NAME,

1199: l_dummy NUMBER (1);
1200:
1201: CURSOR C_LAST_INVOICE IS
1202: SELECT RA_CUSTOMER_TRX.TRX_NUMBER,
1203: RA_CUST_TRX_TYPES.NAME,
1204: AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,
1205: AR_PAYMENT_SCHEDULES.AMOUNT_DUE_ORIGINAL,
1206: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,functional_currency, ' ',
1207: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),

Line 1210: FROM RA_CUST_TRX_TYPES,

1206: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,functional_currency, ' ',
1207: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),
1208: RA_CUSTOMER_TRX.TRX_DATE,
1209: TO_CHAR(ROUND(TRUNC(SYSDATE) - RA_CUSTOMER_TRX.TRX_DATE))
1210: FROM RA_CUST_TRX_TYPES,
1211: AR_PAYMENT_SCHEDULES,
1212: RA_CUSTOMER_TRX
1213: WHERE AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID = RA_CUSTOMER_TRX.CUSTOMER_TRX_ID
1214: AND RA_CUSTOMER_TRX.CUST_TRX_TYPE_ID = RA_CUST_TRX_TYPES.CUST_TRX_TYPE_ID

Line 1214: AND RA_CUSTOMER_TRX.CUST_TRX_TYPE_ID = RA_CUST_TRX_TYPES.CUST_TRX_TYPE_ID

1210: FROM RA_CUST_TRX_TYPES,
1211: AR_PAYMENT_SCHEDULES,
1212: RA_CUSTOMER_TRX
1213: WHERE AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID = RA_CUSTOMER_TRX.CUSTOMER_TRX_ID
1214: AND RA_CUSTOMER_TRX.CUST_TRX_TYPE_ID = RA_CUST_TRX_TYPES.CUST_TRX_TYPE_ID
1215: AND RA_CUSTOMER_TRX.BILL_TO_CUSTOMER_ID = CUSTOMER_ID
1216: AND AR_PAYMENT_SCHEDULES.Customer_site_use_id = site_use_id
1217: AND AR_PAYMENT_SCHEDULES.CLASS || '' = 'INV'
1218: ORDER BY RA_CUSTOMER_TRX.TRX_DATE DESC,

Line 1313: FROM RA_CUST_TRX_TYPES TYPES, RA_CUSTOMER_TRX TRX1, AR_PAYMENT_SCHEDULES PS,

1309: TRX1.TRX_DATE,
1310: ROUND(TRUNC(SYSDATE) - TRX1.TRX_DATE),
1311: TRX2.CUSTOMER_TRX_ID,
1312: TRX1.CUSTOMER_TRX_ID
1313: FROM RA_CUST_TRX_TYPES TYPES, RA_CUSTOMER_TRX TRX1, AR_PAYMENT_SCHEDULES PS,
1314: RA_CUSTOMER_TRX TRX2, AR_RECEIVABLE_APPLICATIONS APP
1315: WHERE TRX1.CUST_TRX_TYPE_ID = TYPES.CUST_TRX_TYPE_ID
1316: AND TRX1.BILL_TO_CUSTOMER_ID = CUSTOMER_ID_1
1317: AND APP.APPLIED_CUSTOMER_TRX_ID = TRX2.CUSTOMER_TRX_ID (+)

Line 1449: RA_CUST_TRX_TYPES.NAME,

1445: l_dummy NUMBER (1);
1446:
1447: CURSOR C_guar IS
1448: SELECT RA_CUSTOMER_TRX.TRX_NUMBER,
1449: RA_CUST_TRX_TYPES.NAME,
1450: AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,
1451: AR_PAYMENT_SCHEDULES.AMOUNT_DUE_ORIGINAL,
1452: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,functional_currency, ' ',
1453: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),

Line 1456: FROM RA_CUST_TRX_TYPES,

1452: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,functional_currency, ' ',
1453: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),
1454: RA_CUSTOMER_TRX.TRX_DATE,
1455: ROUND(TRUNC(SYSDATE) - RA_CUSTOMER_TRX.TRX_DATE)
1456: FROM RA_CUST_TRX_TYPES,
1457: RA_CUSTOMER_TRX,
1458: AR_PAYMENT_SCHEDULES
1459: WHERE AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID = RA_CUSTOMER_TRX.CUSTOMER_TRX_ID
1460: AND RA_CUSTOMER_TRX.CUST_TRX_TYPE_ID = RA_CUST_TRX_TYPES.CUST_TRX_TYPE_ID

Line 1460: AND RA_CUSTOMER_TRX.CUST_TRX_TYPE_ID = RA_CUST_TRX_TYPES.CUST_TRX_TYPE_ID

1456: FROM RA_CUST_TRX_TYPES,
1457: RA_CUSTOMER_TRX,
1458: AR_PAYMENT_SCHEDULES
1459: WHERE AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID = RA_CUSTOMER_TRX.CUSTOMER_TRX_ID
1460: AND RA_CUSTOMER_TRX.CUST_TRX_TYPE_ID = RA_CUST_TRX_TYPES.CUST_TRX_TYPE_ID
1461: AND RA_CUSTOMER_TRX.BILL_TO_CUSTOMER_ID = CUSTOMER_ID
1462: AND AR_PAYMENT_SCHEDULES.Customer_site_use_id = site_use_id
1463: AND AR_PAYMENT_SCHEDULES.CLASS = 'GUAR'
1464: ORDER BY RA_CUSTOMER_TRX.TRX_DATE DESC,

Line 1544: RA_CUST_TRX_TYPES.NAME,

1540: l_dummy NUMBER (1);
1541:
1542: CURSOR C_DEP IS
1543: SELECT RA_CUSTOMER_TRX.TRX_NUMBER,
1544: RA_CUST_TRX_TYPES.NAME,
1545: AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,
1546: AR_PAYMENT_SCHEDULES.AMOUNT_DUE_ORIGINAL,
1547: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,functional_currency, ' ',
1548: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),

Line 1551: FROM RA_CUST_TRX_TYPES,

1547: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,functional_currency, ' ',
1548: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),
1549: RA_CUSTOMER_TRX.TRX_DATE,
1550: ROUND(TRUNC(SYSDATE) - RA_CUSTOMER_TRX.TRX_DATE)
1551: FROM RA_CUST_TRX_TYPES,
1552: RA_CUSTOMER_TRX,
1553: AR_PAYMENT_SCHEDULES
1554: WHERE AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID = RA_CUSTOMER_TRX.CUSTOMER_TRX_ID
1555: AND RA_CUSTOMER_TRX.CUST_TRX_TYPE_ID = RA_CUST_TRX_TYPES.CUST_TRX_TYPE_ID

Line 1555: AND RA_CUSTOMER_TRX.CUST_TRX_TYPE_ID = RA_CUST_TRX_TYPES.CUST_TRX_TYPE_ID

1551: FROM RA_CUST_TRX_TYPES,
1552: RA_CUSTOMER_TRX,
1553: AR_PAYMENT_SCHEDULES
1554: WHERE AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID = RA_CUSTOMER_TRX.CUSTOMER_TRX_ID
1555: AND RA_CUSTOMER_TRX.CUST_TRX_TYPE_ID = RA_CUST_TRX_TYPES.CUST_TRX_TYPE_ID
1556: AND RA_CUSTOMER_TRX.BILL_TO_CUSTOMER_ID = CUSTOMER_ID
1557: AND AR_PAYMENT_SCHEDULES.Customer_site_use_id = site_use_id
1558: AND AR_PAYMENT_SCHEDULES.CLASS = 'DEP'
1559: ORDER BY RA_CUSTOMER_TRX.TRX_DATE DESC,

Line 1636: RA_CUST_TRX_TYPES.NAME,

1632: l_dummy NUMBER (1);
1633:
1634: CURSOR C_DM IS
1635: SELECT RA_CUSTOMER_TRX.TRX_NUMBER,
1636: RA_CUST_TRX_TYPES.NAME,
1637: AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,
1638: AR_PAYMENT_SCHEDULES.AMOUNT_DUE_ORIGINAL,
1639: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,functional_currency, ' ',
1640: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),

Line 1643: FROM RA_CUST_TRX_TYPES,

1639: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,functional_currency, ' ',
1640: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),
1641: RA_CUSTOMER_TRX.TRX_DATE,
1642: ROUND(TRUNC(SYSDATE) - RA_CUSTOMER_TRX.TRX_DATE)
1643: FROM RA_CUST_TRX_TYPES,
1644: RA_CUSTOMER_TRX,
1645: AR_PAYMENT_SCHEDULES
1646: WHERE AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID = RA_CUSTOMER_TRX.CUSTOMER_TRX_ID
1647: AND RA_CUSTOMER_TRX.CUST_TRX_TYPE_ID = RA_CUST_TRX_TYPES.CUST_TRX_TYPE_ID

Line 1647: AND RA_CUSTOMER_TRX.CUST_TRX_TYPE_ID = RA_CUST_TRX_TYPES.CUST_TRX_TYPE_ID

1643: FROM RA_CUST_TRX_TYPES,
1644: RA_CUSTOMER_TRX,
1645: AR_PAYMENT_SCHEDULES
1646: WHERE AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID = RA_CUSTOMER_TRX.CUSTOMER_TRX_ID
1647: AND RA_CUSTOMER_TRX.CUST_TRX_TYPE_ID = RA_CUST_TRX_TYPES.CUST_TRX_TYPE_ID
1648: AND RA_CUSTOMER_TRX.BILL_TO_CUSTOMER_ID = CUSTOMER_ID
1649: AND AR_PAYMENT_SCHEDULES.Customer_site_use_id = site_use_id
1650: AND AR_PAYMENT_SCHEDULES.CLASS = 'DM'
1651: ORDER BY RA_CUSTOMER_TRX.TRX_DATE DESC,

Line 1730: RA_CUST_TRX_TYPES.NAME,

1726: l_dummy NUMBER (1);
1727:
1728: CURSOR C_CB IS
1729: SELECT RA_CUSTOMER_TRX.TRX_NUMBER,
1730: RA_CUST_TRX_TYPES.NAME,
1731: AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,
1732: AR_PAYMENT_SCHEDULES.AMOUNT_DUE_ORIGINAL,
1733: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE, functional_currency, ' ',
1734: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),

Line 1737: FROM RA_CUST_TRX_TYPES,

1733: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE, functional_currency, ' ',
1734: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),
1735: RA_CUSTOMER_TRX.TRX_DATE,
1736: ROUND(TRUNC(SYSDATE) - RA_CUSTOMER_TRX.TRX_DATE)
1737: FROM RA_CUST_TRX_TYPES,
1738: RA_CUSTOMER_TRX,
1739: AR_PAYMENT_SCHEDULES
1740: WHERE AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID = RA_CUSTOMER_TRX.CUSTOMER_TRX_ID
1741: AND RA_CUSTOMER_TRX.CUST_TRX_TYPE_ID = RA_CUST_TRX_TYPES.CUST_TRX_TYPE_ID

Line 1741: AND RA_CUSTOMER_TRX.CUST_TRX_TYPE_ID = RA_CUST_TRX_TYPES.CUST_TRX_TYPE_ID

1737: FROM RA_CUST_TRX_TYPES,
1738: RA_CUSTOMER_TRX,
1739: AR_PAYMENT_SCHEDULES
1740: WHERE AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID = RA_CUSTOMER_TRX.CUSTOMER_TRX_ID
1741: AND RA_CUSTOMER_TRX.CUST_TRX_TYPE_ID = RA_CUST_TRX_TYPES.CUST_TRX_TYPE_ID
1742: AND RA_CUSTOMER_TRX.BILL_TO_CUSTOMER_ID = CUSTOMER_ID
1743: AND AR_PAYMENT_SCHEDULES.Customer_site_use_id = site_use_id
1744: AND AR_PAYMENT_SCHEDULES.CLASS = 'CB'
1745: ORDER BY RA_CUSTOMER_TRX.TRX_DATE DESC,