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_RECEIPTS

Line 431: AR_CASH_RECEIPTS CR

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'
435: AND CRH.CURRENT_RECORD_FLAG = 'Y'

Line 465: AR_CASH_RECEIPTS CR

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'
469: AND CRH.CURRENT_RECORD_FLAG = 'Y'

Line 506: AR_CASH_RECEIPTS CR

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'
510: AND CRH.CURRENT_RECORD_FLAG = 'Y'

Line 541: AR_CASH_RECEIPTS CR

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'
545: AND CRH.CURRENT_RECORD_FLAG = 'Y'

Line 585: AR_CASH_RECEIPTS CR

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'
589: AND CRH.CURRENT_RECORD_FLAG = 'Y'

Line 619: AR_CASH_RECEIPTS CR

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'
623: AND CRH.CURRENT_RECORD_FLAG = 'Y'

Line 660: AR_CASH_RECEIPTS CR

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'
664: AND CRH.CURRENT_RECORD_FLAG = 'Y'

Line 695: AR_CASH_RECEIPTS CR

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'
699: AND CRH.CURRENT_RECORD_FLAG = 'Y'

Line 1403: AR_CASH_RECEIPTS CR

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'
1407: AND CRH.CURRENT_RECORD_FLAG = 'Y'

Line 1437: AR_CASH_RECEIPTS CR

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'
1441: AND CRH.CURRENT_RECORD_FLAG = 'Y'

Line 1478: AR_CASH_RECEIPTS CR

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'
1482: AND CRH.CURRENT_RECORD_FLAG = 'Y'

Line 1513: AR_CASH_RECEIPTS CR

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'
1517: AND CRH.CURRENT_RECORD_FLAG = 'Y'

Line 1557: AR_CASH_RECEIPTS CR

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'
1561: AND CRH.CURRENT_RECORD_FLAG = 'Y'

Line 1591: AR_CASH_RECEIPTS CR

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'
1595: AND CRH.CURRENT_RECORD_FLAG = 'Y'

Line 1632: AR_CASH_RECEIPTS CR

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'
1636: AND CRH.CURRENT_RECORD_FLAG = 'Y'

Line 1667: AR_CASH_RECEIPTS CR

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'
1671: AND CRH.CURRENT_RECORD_FLAG = 'Y'