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.OKL_CONTRACT_INFO dependencies on AR_PAYMENT_SCHEDULES

Line 676: ,ar_payment_schedules aps

672: -- Get days past due for a contract for invoices
673: /*CURSOR days_past_due_csr(p_contract_id IN NUMBER) IS
674: SELECT min(aps.due_date)
675: FROM okl_cnsld_ar_strms_b ocas
676: ,ar_payment_schedules aps
677: WHERE ocas.khr_id = p_contract_id
678: AND ocas.receivables_invoice_id = aps.customer_trx_id
679: AND aps.class = 'INV'
680: AND aps.due_date < sysdate

Line 686: ,ar_payment_schedules aps

682:
683: CURSOR days_past_due_csr(p_contract_id IN NUMBER) IS
684: SELECT min(aps.due_date)
685: FROM okl_bpd_tld_ar_lines_v ocas
686: ,ar_payment_schedules aps
687: WHERE ocas.khr_id = p_contract_id
688: AND ocas.customer_trx_id = aps.customer_trx_id
689: AND aps.class = 'INV'
690: AND aps.due_date < sysdate

Line 744: ,ar_payment_schedules aps

740: -- Get AMount past due for a contract
741: /*CURSOR amount_past_due_csr(p_contract_id IN NUMBER, p_sty_id IN NUMBER) IS
742: SELECT SUM(NVL(aps.amount_due_remaining, 0)) past_due_amount
743: FROM okl_cnsld_ar_strms_b ocas
744: ,ar_payment_schedules aps
745: ,okl_strm_type_v strm
746: WHERE ocas.khr_id = p_contract_id
747: AND ocas.receivables_invoice_id = aps.customer_trx_id
748: AND aps.class ='INV'

Line 757: ,ar_payment_schedules aps

753:
754: CURSOR amount_past_due_csr(p_contract_id IN NUMBER, p_sty_id IN NUMBER) IS
755: SELECT SUM(NVL(aps.amount_due_remaining, 0)) past_due_amount
756: FROM okl_bpd_tld_ar_lines_v ocas
757: ,ar_payment_schedules aps
758: ,okl_strm_type_v strm
759: WHERE ocas.khr_id = p_contract_id
760: AND ocas.customer_trx_id = aps.customer_trx_id
761: AND aps.class ='INV'

Line 840: ,AR_PAYMENT_SCHEDULES APS

836: ,aps.due_date due_date
837: ,SUM(aps.amount_due_original) amt
838: ,lsm.khr_id khr_id
839: FROM OKL_CNSLD_AR_STRMS_B LSM
840: ,AR_PAYMENT_SCHEDULES APS
841: WHERE lsm.receivables_invoice_id = aps.customer_trx_id
842: GROUP BY khr_id, due_date ) amount_date
843: WHERE amount_date.days=(SELECT MIN(next_due.days)
844: FROM (SELECT (SYSDATE-due_date) days

Line 849: ,AR_PAYMENT_SCHEDULES APS

845: ,aps.due_date due_date
846: ,SUM(aps.amount_due_original) amt
847: ,lsm.khr_id khr_id
848: FROM OKL_CNSLD_AR_STRMS_B LSM
849: ,AR_PAYMENT_SCHEDULES APS
850: WHERE lsm.receivables_invoice_id = aps.customer_trx_id
851: GROUP BY khr_id, due_date) next_due
852: WHERE khr_id = p_contract_id
853: AND SIGN(next_due.days) = -1); */

Line 862: ,AR_PAYMENT_SCHEDULES APS

858: ,aps.due_date due_date
859: ,SUM(aps.amount_due_original) amt
860: ,lsm.khr_id khr_id
861: FROM OKL_BPD_TLD_AR_LINES_V LSM
862: ,AR_PAYMENT_SCHEDULES APS
863: WHERE lsm.customer_trx_id = aps.customer_trx_id
864: GROUP BY khr_id, due_date ) amount_date
865: WHERE amount_date.days=(SELECT MIN(next_due.days)
866: FROM (SELECT (SYSDATE-due_date) days

Line 871: ,AR_PAYMENT_SCHEDULES APS

867: ,aps.due_date due_date
868: ,SUM(aps.amount_due_original) amt
869: ,lsm.khr_id khr_id
870: FROM OKL_BPD_TLD_AR_LINES_V LSM
871: ,AR_PAYMENT_SCHEDULES APS
872: WHERE lsm.customer_trx_id = aps.customer_trx_id
873: GROUP BY khr_id, due_date) next_due
874: WHERE khr_id = p_contract_id
875: AND SIGN(next_due.days) = -1); */

Line 884: ,AR_PAYMENT_SCHEDULES APS

880: CURSOR next_due_csr IS
881: SELECT SUM(aps.amount_due_original) amt,
882: aps.due_date due_date
883: FROM okl_bpd_tld_ar_lines_v LSM
884: ,AR_PAYMENT_SCHEDULES APS
885: WHERE lsm.customer_trx_id = aps.customer_trx_id
886: AND lsm.khr_id = p_contract_id
887: AND due_date>SYSDATE
888: GROUP BY aps.due_date , lsm.khr_id

Line 932: ,AR_PAYMENT_SCHEDULES APS

928: ,aps.due_date due_date
929: ,SUM(aps.amount_due_original) amt
930: ,lsm.khr_id khr_id
931: FROM OKL_CNSLD_AR_STRMS_B LSM
932: ,AR_PAYMENT_SCHEDULES APS
933: WHERE lsm.receivables_invoice_id = aps.customer_trx_id
934: GROUP BY khr_id, due_date ) amount_date
935: WHERE amount_date.days=(SELECT MIN(next_due.days)
936: FROM (SELECT (SYSDATE-due_date) days

Line 941: ,AR_PAYMENT_SCHEDULES APS

937: ,aps.due_date due_date
938: ,SUM(aps.amount_due_original) amt
939: ,lsm.khr_id khr_id
940: FROM OKL_CNSLD_AR_STRMS_B LSM
941: ,AR_PAYMENT_SCHEDULES APS
942: WHERE lsm.receivables_invoice_id = aps.customer_trx_id
943: GROUP BY khr_id, due_date) next_due
944: WHERE khr_id = p_contract_id
945: AND SIGN(next_due.days) = 1); */

Line 954: ,AR_PAYMENT_SCHEDULES APS

950: ,aps.due_date due_date
951: ,SUM(aps.amount_due_original) amt
952: ,lsm.khr_id khr_id
953: FROM okl_bpd_tld_ar_lines_v LSM
954: ,AR_PAYMENT_SCHEDULES APS
955: WHERE lsm.customer_trx_id = aps.customer_trx_id
956: GROUP BY khr_id, due_date ) amount_date
957: WHERE amount_date.days=(SELECT MIN(next_due.days)
958: FROM (SELECT (SYSDATE-due_date) days

Line 963: ,AR_PAYMENT_SCHEDULES APS

959: ,aps.due_date due_date
960: ,SUM(aps.amount_due_original) amt
961: ,lsm.khr_id khr_id
962: FROM okl_bpd_tld_ar_lines_v LSM
963: ,AR_PAYMENT_SCHEDULES APS
964: WHERE lsm.customer_trx_id = aps.customer_trx_id
965: GROUP BY khr_id, due_date) next_due
966: WHERE khr_id = p_contract_id
967: AND SIGN(next_due.days) = 1); */

Line 975: ,AR_PAYMENT_SCHEDULES APS

971: CURSOR last_due_csr IS
972: SELECT SUM(aps.amount_due_original) amt,
973: aps.due_date due_date
974: FROM okl_bpd_tld_ar_lines_v LSM
975: ,AR_PAYMENT_SCHEDULES APS
976: WHERE lsm.customer_trx_id = aps.customer_trx_id
977: AND lsm.khr_id = p_contract_id
978: AND due_date<=SYSDATE
979: GROUP BY aps.due_date , lsm.khr_id

Line 1068: ,ar_payment_schedules aps

1064:
1065: /* CURSOR outstanding_rcvble_csr(p_sty_id number) IS
1066: SELECT SUM(NVL(aps.amount_due_remaining, 0)) past_due_amount
1067: FROM okl_cnsld_ar_strms_b ocas
1068: ,ar_payment_schedules aps
1069: ,okl_strm_type_v strm
1070: WHERE ocas.khr_id = p_contract_id
1071: AND ocas.receivables_invoice_id = aps.customer_trx_id
1072: AND aps.class ='INV'

Line 1081: ,ar_payment_schedules aps

1077:
1078: CURSOR outstanding_rcvble_csr(p_sty_id number) IS
1079: SELECT SUM(NVL(aps.amount_due_remaining, 0)) past_due_amount
1080: FROM okl_bpd_tld_ar_lines_v ocas
1081: ,ar_payment_schedules aps
1082: ,okl_strm_type_v strm
1083: WHERE ocas.khr_id = p_contract_id
1084: AND ocas.customer_trx_id = aps.customer_trx_id
1085: AND aps.class ='INV'