APPS.ONT_OEXOECCH_XMLP_PKG dependencies on AR_PAYMENT_SCHEDULES

Line 418: AR_PAYMENT_SCHEDULES

414: NVL(SUM(AMOUNT_DUE_REMAINING)
415: ,0)
416: INTO L_REC_BAL_CREDIT
417: FROM
418: AR_PAYMENT_SCHEDULES
419: WHERE CUSTOMER_ID = CUSTOMER_ID
420: AND INVOICE_CURRENCY_CODE = CURRENCY1
421: AND NVL(RECEIPT_CONFIRMED_FLAG
422: ,'Y') = 'Y';

Line 451: AR_PAYMENT_SCHEDULES

447: NVL(SUM(AMOUNT_DUE_REMAINING)
448: ,0)
449: INTO L_REC_BAL_CREDIT
450: FROM
451: AR_PAYMENT_SCHEDULES
452: WHERE CUSTOMER_ID = CUSTOMER_ID
453: AND INVOICE_CURRENCY_CODE = CURRENCY1
454: AND NVL(RECEIPT_CONFIRMED_FLAG
455: ,'Y') = 'Y'

Line 493: AR_PAYMENT_SCHEDULES

489: NVL(SUM(AMOUNT_DUE_REMAINING)
490: ,0)
491: INTO L_REC_BAL_CREDIT
492: FROM
493: AR_PAYMENT_SCHEDULES
494: WHERE CUSTOMER_SITE_USE_ID = C_COMPUTE_AMOUNTSFORMULA.SITE_USE_ID
495: AND NVL(RECEIPT_CONFIRMED_FLAG
496: ,'Y') = 'Y'
497: AND INVOICE_CURRENCY_CODE = CURRENCY1;

Line 527: AR_PAYMENT_SCHEDULES

523: NVL(SUM(AMOUNT_DUE_REMAINING)
524: ,0)
525: INTO L_REC_BAL_CREDIT
526: FROM
527: AR_PAYMENT_SCHEDULES
528: WHERE CUSTOMER_SITE_USE_ID = C_COMPUTE_AMOUNTSFORMULA.SITE_USE_ID
529: AND NVL(RECEIPT_CONFIRMED_FLAG
530: ,'Y') = 'Y'
531: AND INVOICE_CURRENCY_CODE = CURRENCY1

Line 572: AR_PAYMENT_SCHEDULES

568: NVL(SUM(AMOUNT_DUE_REMAINING)
569: ,0)
570: INTO L_REC_BAL_SHIP
571: FROM
572: AR_PAYMENT_SCHEDULES
573: WHERE CUSTOMER_ID = CUSTOMER_ID
574: AND INVOICE_CURRENCY_CODE = CURRENCY1
575: AND NVL(RECEIPT_CONFIRMED_FLAG
576: ,'Y') = 'Y';

Line 605: AR_PAYMENT_SCHEDULES

601: NVL(SUM(AMOUNT_DUE_REMAINING)
602: ,0)
603: INTO L_REC_BAL_SHIP
604: FROM
605: AR_PAYMENT_SCHEDULES
606: WHERE CUSTOMER_ID = CUSTOMER_ID
607: AND INVOICE_CURRENCY_CODE = CURRENCY1
608: AND NVL(RECEIPT_CONFIRMED_FLAG
609: ,'Y') = 'Y'

Line 647: AR_PAYMENT_SCHEDULES

643: NVL(SUM(AMOUNT_DUE_REMAINING)
644: ,0)
645: INTO L_REC_BAL_SHIP
646: FROM
647: AR_PAYMENT_SCHEDULES
648: WHERE CUSTOMER_SITE_USE_ID = C_COMPUTE_AMOUNTSFORMULA.SITE_USE_ID
649: AND NVL(RECEIPT_CONFIRMED_FLAG
650: ,'Y') = 'Y'
651: AND INVOICE_CURRENCY_CODE = CURRENCY1;

Line 681: AR_PAYMENT_SCHEDULES

677: NVL(SUM(AMOUNT_DUE_REMAINING)
678: ,0)
679: INTO L_REC_BAL_SHIP
680: FROM
681: AR_PAYMENT_SCHEDULES
682: WHERE CUSTOMER_SITE_USE_ID = C_COMPUTE_AMOUNTSFORMULA.SITE_USE_ID
683: AND NVL(RECEIPT_CONFIRMED_FLAG
684: ,'Y') = 'Y'
685: AND INVOICE_CURRENCY_CODE = CURRENCY1

Line 1390: AR_PAYMENT_SCHEDULES

1386: NVL(SUM(AMOUNT_DUE_REMAINING)
1387: ,0)
1388: INTO L_REC_BAL_PICK
1389: FROM
1390: AR_PAYMENT_SCHEDULES
1391: WHERE CUSTOMER_ID = CUSTOMER_ID
1392: AND INVOICE_CURRENCY_CODE = CURRENCY1
1393: AND NVL(RECEIPT_CONFIRMED_FLAG
1394: ,'Y') = 'Y';

Line 1423: AR_PAYMENT_SCHEDULES

1419: NVL(SUM(AMOUNT_DUE_REMAINING)
1420: ,0)
1421: INTO L_REC_BAL_PICK
1422: FROM
1423: AR_PAYMENT_SCHEDULES
1424: WHERE CUSTOMER_ID = CUSTOMER_ID
1425: AND INVOICE_CURRENCY_CODE = CURRENCY1
1426: AND NVL(RECEIPT_CONFIRMED_FLAG
1427: ,'Y') = 'Y'

Line 1465: AR_PAYMENT_SCHEDULES

1461: NVL(SUM(AMOUNT_DUE_REMAINING)
1462: ,0)
1463: INTO L_REC_BAL_PICK
1464: FROM
1465: AR_PAYMENT_SCHEDULES
1466: WHERE CUSTOMER_SITE_USE_ID = C_COMPUTE_AMOUNTSFORMULA.SITE_USE_ID
1467: AND NVL(RECEIPT_CONFIRMED_FLAG
1468: ,'Y') = 'Y'
1469: AND INVOICE_CURRENCY_CODE = CURRENCY1;

Line 1499: AR_PAYMENT_SCHEDULES

1495: NVL(SUM(AMOUNT_DUE_REMAINING)
1496: ,0)
1497: INTO L_REC_BAL_PICK
1498: FROM
1499: AR_PAYMENT_SCHEDULES
1500: WHERE CUSTOMER_SITE_USE_ID = C_COMPUTE_AMOUNTSFORMULA.SITE_USE_ID
1501: AND NVL(RECEIPT_CONFIRMED_FLAG
1502: ,'Y') = 'Y'
1503: AND INVOICE_CURRENCY_CODE = CURRENCY1

Line 1544: AR_PAYMENT_SCHEDULES

1540: NVL(SUM(AMOUNT_DUE_REMAINING)
1541: ,0)
1542: INTO L_REC_BAL_PACK
1543: FROM
1544: AR_PAYMENT_SCHEDULES
1545: WHERE CUSTOMER_ID = CUSTOMER_ID
1546: AND INVOICE_CURRENCY_CODE = CURRENCY1
1547: AND NVL(RECEIPT_CONFIRMED_FLAG
1548: ,'Y') = 'Y';

Line 1577: AR_PAYMENT_SCHEDULES

1573: NVL(SUM(AMOUNT_DUE_REMAINING)
1574: ,0)
1575: INTO L_REC_BAL_PACK
1576: FROM
1577: AR_PAYMENT_SCHEDULES
1578: WHERE CUSTOMER_ID = CUSTOMER_ID
1579: AND INVOICE_CURRENCY_CODE = CURRENCY1
1580: AND NVL(RECEIPT_CONFIRMED_FLAG
1581: ,'Y') = 'Y'

Line 1619: AR_PAYMENT_SCHEDULES

1615: NVL(SUM(AMOUNT_DUE_REMAINING)
1616: ,0)
1617: INTO L_REC_BAL_PACK
1618: FROM
1619: AR_PAYMENT_SCHEDULES
1620: WHERE CUSTOMER_SITE_USE_ID = C_COMPUTE_AMOUNTSFORMULA.SITE_USE_ID
1621: AND NVL(RECEIPT_CONFIRMED_FLAG
1622: ,'Y') = 'Y'
1623: AND INVOICE_CURRENCY_CODE = CURRENCY1;

Line 1653: AR_PAYMENT_SCHEDULES

1649: NVL(SUM(AMOUNT_DUE_REMAINING)
1650: ,0)
1651: INTO L_REC_BAL_PACK
1652: FROM
1653: AR_PAYMENT_SCHEDULES
1654: WHERE CUSTOMER_SITE_USE_ID = C_COMPUTE_AMOUNTSFORMULA.SITE_USE_ID
1655: AND NVL(RECEIPT_CONFIRMED_FLAG
1656: ,'Y') = 'Y'
1657: AND INVOICE_CURRENCY_CODE = CURRENCY1