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.ONT_OEXOECCH_XMLP_PKG dependencies on AR_CASH_RECEIPT_HISTORY

Line 430: AR_CASH_RECEIPT_HISTORY CRH,

426: NVL(SUM(CRH.AMOUNT)
427: ,0) + L_REC_BAL_CREDIT
428: INTO L_REC_BAL_CREDIT
429: FROM
430: AR_CASH_RECEIPT_HISTORY CRH,
431: AR_CASH_RECEIPTS CR
432: WHERE CRH.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
433: AND NVL(CR.CONFIRMED_FLAG
434: ,'Y') = 'Y'

Line 464: AR_CASH_RECEIPT_HISTORY CRH,

460: NVL(SUM(CRH.AMOUNT)
461: ,0) + L_REC_BAL_CREDIT
462: INTO L_REC_BAL_CREDIT
463: FROM
464: AR_CASH_RECEIPT_HISTORY CRH,
465: AR_CASH_RECEIPTS CR
466: WHERE CRH.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
467: AND NVL(CR.CONFIRMED_FLAG
468: ,'Y') = 'Y'

Line 505: AR_CASH_RECEIPT_HISTORY CRH,

501: NVL(SUM(CRH.AMOUNT)
502: ,0) + L_REC_BAL_CREDIT
503: INTO L_REC_BAL_CREDIT
504: FROM
505: AR_CASH_RECEIPT_HISTORY CRH,
506: AR_CASH_RECEIPTS CR
507: WHERE CRH.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
508: AND NVL(CR.CONFIRMED_FLAG
509: ,'Y') = 'Y'

Line 540: AR_CASH_RECEIPT_HISTORY CRH,

536: NVL(SUM(CRH.AMOUNT)
537: ,0) + L_REC_BAL_CREDIT
538: INTO L_REC_BAL_CREDIT
539: FROM
540: AR_CASH_RECEIPT_HISTORY CRH,
541: AR_CASH_RECEIPTS CR
542: WHERE CRH.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
543: AND NVL(CR.CONFIRMED_FLAG
544: ,'Y') = 'Y'

Line 584: AR_CASH_RECEIPT_HISTORY CRH,

580: NVL(SUM(CRH.AMOUNT)
581: ,0) + L_REC_BAL_SHIP
582: INTO L_REC_BAL_SHIP
583: FROM
584: AR_CASH_RECEIPT_HISTORY CRH,
585: AR_CASH_RECEIPTS CR
586: WHERE CRH.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
587: AND NVL(CR.CONFIRMED_FLAG
588: ,'Y') = 'Y'

Line 618: AR_CASH_RECEIPT_HISTORY CRH,

614: NVL(SUM(CRH.AMOUNT)
615: ,0) + L_REC_BAL_SHIP
616: INTO L_REC_BAL_SHIP
617: FROM
618: AR_CASH_RECEIPT_HISTORY CRH,
619: AR_CASH_RECEIPTS CR
620: WHERE CRH.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
621: AND NVL(CR.CONFIRMED_FLAG
622: ,'Y') = 'Y'

Line 659: AR_CASH_RECEIPT_HISTORY CRH,

655: NVL(SUM(CRH.AMOUNT)
656: ,0) + L_REC_BAL_SHIP
657: INTO L_REC_BAL_SHIP
658: FROM
659: AR_CASH_RECEIPT_HISTORY CRH,
660: AR_CASH_RECEIPTS CR
661: WHERE CRH.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
662: AND NVL(CR.CONFIRMED_FLAG
663: ,'Y') = 'Y'

Line 694: AR_CASH_RECEIPT_HISTORY CRH,

690: NVL(SUM(CRH.AMOUNT)
691: ,0) + L_REC_BAL_SHIP
692: INTO L_REC_BAL_SHIP
693: FROM
694: AR_CASH_RECEIPT_HISTORY CRH,
695: AR_CASH_RECEIPTS CR
696: WHERE CRH.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
697: AND NVL(CR.CONFIRMED_FLAG
698: ,'Y') = 'Y'

Line 1402: AR_CASH_RECEIPT_HISTORY CRH,

1398: NVL(SUM(CRH.AMOUNT)
1399: ,0) + L_REC_BAL_PICK
1400: INTO L_REC_BAL_PICK
1401: FROM
1402: AR_CASH_RECEIPT_HISTORY CRH,
1403: AR_CASH_RECEIPTS CR
1404: WHERE CRH.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
1405: AND NVL(CR.CONFIRMED_FLAG
1406: ,'Y') = 'Y'

Line 1436: AR_CASH_RECEIPT_HISTORY CRH,

1432: NVL(SUM(CRH.AMOUNT)
1433: ,0) + L_REC_BAL_PICK
1434: INTO L_REC_BAL_PICK
1435: FROM
1436: AR_CASH_RECEIPT_HISTORY CRH,
1437: AR_CASH_RECEIPTS CR
1438: WHERE CRH.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
1439: AND NVL(CR.CONFIRMED_FLAG
1440: ,'Y') = 'Y'

Line 1477: AR_CASH_RECEIPT_HISTORY CRH,

1473: NVL(SUM(CRH.AMOUNT)
1474: ,0) + L_REC_BAL_PICK
1475: INTO L_REC_BAL_PICK
1476: FROM
1477: AR_CASH_RECEIPT_HISTORY CRH,
1478: AR_CASH_RECEIPTS CR
1479: WHERE CRH.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
1480: AND NVL(CR.CONFIRMED_FLAG
1481: ,'Y') = 'Y'

Line 1512: AR_CASH_RECEIPT_HISTORY CRH,

1508: NVL(SUM(CRH.AMOUNT)
1509: ,0) + L_REC_BAL_PICK
1510: INTO L_REC_BAL_PICK
1511: FROM
1512: AR_CASH_RECEIPT_HISTORY CRH,
1513: AR_CASH_RECEIPTS CR
1514: WHERE CRH.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
1515: AND NVL(CR.CONFIRMED_FLAG
1516: ,'Y') = 'Y'

Line 1556: AR_CASH_RECEIPT_HISTORY CRH,

1552: NVL(SUM(CRH.AMOUNT)
1553: ,0) + L_REC_BAL_PACK
1554: INTO L_REC_BAL_PACK
1555: FROM
1556: AR_CASH_RECEIPT_HISTORY CRH,
1557: AR_CASH_RECEIPTS CR
1558: WHERE CRH.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
1559: AND NVL(CR.CONFIRMED_FLAG
1560: ,'Y') = 'Y'

Line 1590: AR_CASH_RECEIPT_HISTORY CRH,

1586: NVL(SUM(CRH.AMOUNT)
1587: ,0) + L_REC_BAL_PACK
1588: INTO L_REC_BAL_PACK
1589: FROM
1590: AR_CASH_RECEIPT_HISTORY CRH,
1591: AR_CASH_RECEIPTS CR
1592: WHERE CRH.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
1593: AND NVL(CR.CONFIRMED_FLAG
1594: ,'Y') = 'Y'

Line 1631: AR_CASH_RECEIPT_HISTORY CRH,

1627: NVL(SUM(CRH.AMOUNT)
1628: ,0) + L_REC_BAL_PACK
1629: INTO L_REC_BAL_PACK
1630: FROM
1631: AR_CASH_RECEIPT_HISTORY CRH,
1632: AR_CASH_RECEIPTS CR
1633: WHERE CRH.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
1634: AND NVL(CR.CONFIRMED_FLAG
1635: ,'Y') = 'Y'

Line 1666: AR_CASH_RECEIPT_HISTORY CRH,

1662: NVL(SUM(CRH.AMOUNT)
1663: ,0) + L_REC_BAL_PACK
1664: INTO L_REC_BAL_PACK
1665: FROM
1666: AR_CASH_RECEIPT_HISTORY CRH,
1667: AR_CASH_RECEIPTS CR
1668: WHERE CRH.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
1669: AND NVL(CR.CONFIRMED_FLAG
1670: ,'Y') = 'Y'