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_CUSTOMER_TRX

Line 1202: SELECT RA_CUSTOMER_TRX.TRX_NUMBER,

1198: l_last_invoice_days_since VARCHAR2 (100);
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, ' ',

Line 1208: RA_CUSTOMER_TRX.TRX_DATE,

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, '*', ' ')),
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

Line 1209: TO_CHAR(ROUND(TRUNC(SYSDATE) - RA_CUSTOMER_TRX.TRX_DATE))

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, '*', ' ')),
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

Line 1212: RA_CUSTOMER_TRX

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
1215: AND RA_CUSTOMER_TRX.BILL_TO_CUSTOMER_ID = CUSTOMER_ID
1216: AND AR_PAYMENT_SCHEDULES.Customer_site_use_id = site_use_id

Line 1213: WHERE AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID = RA_CUSTOMER_TRX.CUSTOMER_TRX_ID

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
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'

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 1215: AND RA_CUSTOMER_TRX.BILL_TO_CUSTOMER_ID = CUSTOMER_ID

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,
1219: RA_CUSTOMER_TRX.CUSTOMER_TRX_ID DESC

Line 1218: ORDER BY RA_CUSTOMER_TRX.TRX_DATE DESC,

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,
1219: RA_CUSTOMER_TRX.CUSTOMER_TRX_ID DESC
1220: ;
1221:
1222:

Line 1219: RA_CUSTOMER_TRX.CUSTOMER_TRX_ID DESC

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,
1219: RA_CUSTOMER_TRX.CUSTOMER_TRX_ID DESC
1220: ;
1221:
1222:
1223: BEGIN

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 1314: RA_CUSTOMER_TRX TRX2, AR_RECEIVABLE_APPLICATIONS APP

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 (+)
1318: AND APP.CUSTOMER_TRX_ID (+) = TRX1.CUSTOMER_TRX_ID

Line 1374: FROM RA_CUSTOMER_TRX

1370:
1371:
1372: SELECT TRX_NUMBER
1373: INTO l_last_cm_rel_invoice
1374: FROM RA_CUSTOMER_TRX
1375: WHERE CUSTOMER_TRX_ID = c_last_cm_prev_trx
1376: AND BILL_TO_SITE_USE_ID = SITE_USE_ID_1
1377: ;
1378:

Line 1448: SELECT RA_CUSTOMER_TRX.TRX_NUMBER,

1444: l_last_guar_days_since VARCHAR2 (11);
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, ' ',

Line 1454: RA_CUSTOMER_TRX.TRX_DATE,

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, '*', ' ')),
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

Line 1455: ROUND(TRUNC(SYSDATE) - RA_CUSTOMER_TRX.TRX_DATE)

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, '*', ' ')),
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

Line 1457: RA_CUSTOMER_TRX,

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
1461: AND RA_CUSTOMER_TRX.BILL_TO_CUSTOMER_ID = CUSTOMER_ID

Line 1459: WHERE AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID = RA_CUSTOMER_TRX.CUSTOMER_TRX_ID

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
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'

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 1461: AND RA_CUSTOMER_TRX.BILL_TO_CUSTOMER_ID = CUSTOMER_ID

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,
1465: RA_CUSTOMER_TRX.CUSTOMER_TRX_ID DESC

Line 1464: ORDER BY RA_CUSTOMER_TRX.TRX_DATE DESC,

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,
1465: RA_CUSTOMER_TRX.CUSTOMER_TRX_ID DESC
1466: ;
1467:
1468: BEGIN

Line 1465: RA_CUSTOMER_TRX.CUSTOMER_TRX_ID DESC

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,
1465: RA_CUSTOMER_TRX.CUSTOMER_TRX_ID DESC
1466: ;
1467:
1468: BEGIN
1469: c_last_guar_number := '' ;

Line 1543: SELECT RA_CUSTOMER_TRX.TRX_NUMBER,

1539: l_last_dep_days_since VARCHAR2 (11);
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, ' ',

Line 1549: RA_CUSTOMER_TRX.TRX_DATE,

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, '*', ' ')),
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

Line 1550: ROUND(TRUNC(SYSDATE) - RA_CUSTOMER_TRX.TRX_DATE)

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, '*', ' ')),
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

Line 1552: RA_CUSTOMER_TRX,

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
1556: AND RA_CUSTOMER_TRX.BILL_TO_CUSTOMER_ID = CUSTOMER_ID

Line 1554: WHERE AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID = RA_CUSTOMER_TRX.CUSTOMER_TRX_ID

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
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'

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 1556: AND RA_CUSTOMER_TRX.BILL_TO_CUSTOMER_ID = CUSTOMER_ID

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,
1560: RA_CUSTOMER_TRX.CUSTOMER_TRX_ID DESC

Line 1559: ORDER BY RA_CUSTOMER_TRX.TRX_DATE DESC,

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,
1560: RA_CUSTOMER_TRX.CUSTOMER_TRX_ID DESC
1561: ;
1562:
1563: BEGIN

Line 1560: RA_CUSTOMER_TRX.CUSTOMER_TRX_ID DESC

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,
1560: RA_CUSTOMER_TRX.CUSTOMER_TRX_ID DESC
1561: ;
1562:
1563: BEGIN
1564:

Line 1635: SELECT RA_CUSTOMER_TRX.TRX_NUMBER,

1631: l_last_dm_days_since VARCHAR2 (11);
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, ' ',

Line 1641: RA_CUSTOMER_TRX.TRX_DATE,

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, '*', ' ')),
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

Line 1642: ROUND(TRUNC(SYSDATE) - RA_CUSTOMER_TRX.TRX_DATE)

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, '*', ' ')),
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

Line 1644: RA_CUSTOMER_TRX,

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
1648: AND RA_CUSTOMER_TRX.BILL_TO_CUSTOMER_ID = CUSTOMER_ID

Line 1646: WHERE AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID = RA_CUSTOMER_TRX.CUSTOMER_TRX_ID

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
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'

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 1648: AND RA_CUSTOMER_TRX.BILL_TO_CUSTOMER_ID = CUSTOMER_ID

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,
1652: RA_CUSTOMER_TRX.CUSTOMER_TRX_ID DESC

Line 1651: ORDER BY RA_CUSTOMER_TRX.TRX_DATE DESC,

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,
1652: RA_CUSTOMER_TRX.CUSTOMER_TRX_ID DESC
1653: ;
1654:
1655: BEGIN

Line 1652: RA_CUSTOMER_TRX.CUSTOMER_TRX_ID DESC

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,
1652: RA_CUSTOMER_TRX.CUSTOMER_TRX_ID DESC
1653: ;
1654:
1655: BEGIN
1656:

Line 1729: SELECT RA_CUSTOMER_TRX.TRX_NUMBER,

1725: l_last_cb_days_since VARCHAR2 (11);
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, ' ',

Line 1735: RA_CUSTOMER_TRX.TRX_DATE,

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, '*', ' ')),
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

Line 1736: ROUND(TRUNC(SYSDATE) - RA_CUSTOMER_TRX.TRX_DATE)

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, '*', ' ')),
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

Line 1738: RA_CUSTOMER_TRX,

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
1742: AND RA_CUSTOMER_TRX.BILL_TO_CUSTOMER_ID = CUSTOMER_ID

Line 1740: WHERE AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID = RA_CUSTOMER_TRX.CUSTOMER_TRX_ID

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
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'

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,

Line 1742: AND RA_CUSTOMER_TRX.BILL_TO_CUSTOMER_ID = CUSTOMER_ID

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,
1746: RA_CUSTOMER_TRX.CUSTOMER_TRX_ID DESC

Line 1745: ORDER BY RA_CUSTOMER_TRX.TRX_DATE DESC,

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,
1746: RA_CUSTOMER_TRX.CUSTOMER_TRX_ID DESC
1747: ;
1748:
1749: BEGIN

Line 1746: RA_CUSTOMER_TRX.CUSTOMER_TRX_ID DESC

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,
1746: RA_CUSTOMER_TRX.CUSTOMER_TRX_ID DESC
1747: ;
1748:
1749: BEGIN
1750:

Line 1830: RA_CUSTOMER_TRX.TRX_NUMBER

1826: DECODE(AR_CASH_RECEIPTS.CURRENCY_CODE, functional_currency, ' ',
1827: DECODE(AR_CASH_RECEIPTS.EXCHANGE_RATE, NULL, '*', ' ')),
1828: CRH.GL_DATE,
1829: ROUND(TRUNC(SYSDATE) - CRH.GL_DATE),
1830: RA_CUSTOMER_TRX.TRX_NUMBER
1831: FROM AR_LOOKUPS,
1832: AR_CASH_RECEIPTS,
1833: AR_CASH_RECEIPT_HISTORY CRH,
1834: AR_RECEIVABLE_APPLICATIONS,

Line 1835: RA_CUSTOMER_TRX

1831: FROM AR_LOOKUPS,
1832: AR_CASH_RECEIPTS,
1833: AR_CASH_RECEIPT_HISTORY CRH,
1834: AR_RECEIVABLE_APPLICATIONS,
1835: RA_CUSTOMER_TRX
1836: WHERE NVL(AR_CASH_RECEIPTS.TYPE, 'CASH') = AR_LOOKUPS.LOOKUP_CODE
1837: AND AR_LOOKUPS.LOOKUP_TYPE = 'PAYMENT_CATEGORY_TYPE'
1838: AND AR_CASH_RECEIPTS.PAY_FROM_CUSTOMER = CUSTOMER_ID
1839: AND AR_CASH_RECEIPTS.CUSTOMER_SITE_USE_ID = site_use_id

Line 1845: RA_CUSTOMER_TRX.CUSTOMER_TRX_ID (+)

1841: AR_RECEIVABLE_APPLICATIONS.CASH_RECEIPT_ID
1842: AND AR_CASH_RECEIPTS.CASH_RECEIPT_ID = CRH.CASH_RECEIPT_ID
1843: AND CRH.FIRST_POSTED_RECORD_FLAG = 'Y'
1844: AND AR_RECEIVABLE_APPLICATIONS.APPLIED_CUSTOMER_TRX_ID =
1845: RA_CUSTOMER_TRX.CUSTOMER_TRX_ID (+)
1846: ORDER BY AR_CASH_RECEIPTS.CREATION_DATE DESC,
1847: AR_CASH_RECEIPTS.CASH_RECEIPT_ID DESC,
1848: AR_RECEIVABLE_APPLICATIONS.CREATION_DATE DESC
1849: ;