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_SETUPPQVALUES_PVT dependencies on OKL_PDT_QUALITYS_V

Line 201: okl_pdt_qualitys_v pqy

197: SELECT pqy.id pqy_id,pqy.name name,
198: qve.id qve_id,qve.value value
199: FROM okl_pdt_pqy_vals_v pqv,
200: okl_pqy_values_v qve,
201: okl_pdt_qualitys_v pqy
202: WHERE pqv.pdt_id = cp_pdt_id
203: AND pqy.ID = qve.PQY_ID
204: AND qve.ID = pqv.QVE_ID
205: AND pqy.name IN ('LEASE','INVESTOR','TAXOWNER','INTEREST_CALCULATION_BASIS','REVENUE_RECOGNITION_METHOD');

Line 214: okl_pdt_qualitys_v pqy

210: SELECT pqy.id pqy_id,pqy.name name,
211: qve.id qve_id,qve.value value
212: FROM okl_pdt_pqy_vals_v pqv,
213: okl_pqy_values_v qve,
214: okl_pdt_qualitys_v pqy
215: WHERE pqv.pdt_id = cp_pdt_id
216: AND pqy.ID = qve.PQY_ID
217: AND qve.ID = pqv.QVE_ID
218: AND pqy.name IN ('REVENUE_RECOGNITION_METHOD','INTEREST_CALCULATION_BASIS');

Line 545: okl_pdt_qualitys_v b,

541: IF csr_rec.name = 'LEASE' AND csr_rec.value = 'LEASEOP' THEN
542: SELECT COUNT(b.id)
543: INTO l_leaseop_lessee_mismatch
544: FROM OKL_pdt_pqy_vals_V a,
545: okl_pdt_qualitys_v b,
546: okl_pqy_values_v c
547: WHERE a.pdt_ID = p_pqvv_rec.pdt_id
548: AND b.id = c.pqy_id
549: AND c.id = p_pqvv_rec.qve_id

Line 556: okl_pdt_qualitys_v b,

552: ELSIF csr_rec.name = 'TAXOWNER' and csr_rec.value = 'LESSEE' THEN
553: SELECT COUNT(b.id)
554: INTO l_leaseop_lessee_mismatch
555: FROM OKL_pdt_pqy_vals_V a,
556: okl_pdt_qualitys_v b,
557: okl_pqy_values_v c
558: WHERE a.pdt_ID = p_pqvv_rec.pdt_id
559: AND b.id = c.pqy_id
560: AND c.id = p_pqvv_rec.qve_id

Line 569: okl_pdt_qualitys_v b,

565: IF csr_rec.name = 'INTEREST_CALCULATION_BASIS' and csr_rec.value = 'FLOAT_FACTORS' THEN
566: SELECT COUNT(b.id)
567: INTO l_FLT_FAC_loan_rev_mismatch
568: FROM OKL_pdt_pqy_vals_V a,
569: okl_pdt_qualitys_v b,
570: okl_pqy_values_v c
571: WHERE a.pdt_ID = p_pqvv_rec.pdt_id
572: AND b.id = c.pqy_id
573: AND c.id = p_pqvv_rec.qve_id

Line 580: okl_pdt_qualitys_v b,

576: ELSIF csr_rec.name = 'LEASE' and csr_rec.value = 'LOAN-REVOLVING' THEN
577: SELECT COUNT(b.id)
578: INTO l_FLT_FAC_loan_rev_mismatch
579: FROM OKL_pdt_pqy_vals_V a,
580: okl_pdt_qualitys_v b,
581: okl_pqy_values_v c
582: WHERE a.pdt_ID = p_pqvv_rec.pdt_id
583: AND b.id = c.pqy_id
584: AND c.id = p_pqvv_rec.qve_id

Line 594: okl_pdt_qualitys_v b,

590: IF csr_rec.name = 'REVENUE_RECOGNITION_METHOD' and csr_rec.value = 'ESTIMATED_AND_BILLED' THEN
591: SELECT COUNT(b.id)
592: INTO l_FLT_FAC_EST_BILL_mismatch
593: FROM OKL_pdt_pqy_vals_V a,
594: okl_pdt_qualitys_v b,
595: okl_pqy_values_v c
596: WHERE a.pdt_ID = p_pqvv_rec.pdt_id
597: AND b.id = c.pqy_id
598: AND c.id = p_pqvv_rec.qve_id

Line 605: okl_pdt_qualitys_v b,

601: ELSIF csr_rec.name = 'INTEREST_CALCULATION_BASIS' and csr_rec.value = 'FLOAT_FACTORS' THEN
602: SELECT COUNT(b.id)
603: INTO l_FLT_FAC_EST_BILL_mismatch
604: FROM OKL_pdt_pqy_vals_V a,
605: okl_pdt_qualitys_v b,
606: okl_pqy_values_v c
607: WHERE a.pdt_ID = p_pqvv_rec.pdt_id
608: AND b.id = c.pqy_id
609: AND c.id = p_pqvv_rec.qve_id

Line 620: okl_pdt_qualitys_v b,

616: SELECT COUNT(b.id)
617:
618: INTO l_loan_lessor_mismatch
619: FROM OKL_pdt_pqy_vals_V a,
620: okl_pdt_qualitys_v b,
621: okl_pqy_values_v c
622: WHERE a.pdt_ID = p_pqvv_rec.pdt_id
623: AND b.id = c.pqy_id
624: AND c.id = p_pqvv_rec.qve_id

Line 632: okl_pdt_qualitys_v b,

628: ELSIF csr_rec.name = 'TAXOWNER' AND csr_rec.value = 'LESSOR' THEN
629: SELECT COUNT(b.id)
630: INTO l_leaseop_lessee_mismatch
631: FROM OKL_pdt_pqy_vals_V a,
632: okl_pdt_qualitys_v b,
633: okl_pqy_values_v c
634: WHERE a.pdt_ID = p_pqvv_rec.pdt_id
635: AND b.id = c.pqy_id
636: AND c.id = p_pqvv_rec.qve_id

Line 646: okl_pdt_qualitys_v b,

642: SELECT COUNT(b.id)
643:
644: INTO l_loanrev_lessor_mismatch
645: FROM OKL_pdt_pqy_vals_V a,
646: okl_pdt_qualitys_v b,
647: okl_pqy_values_v c
648: WHERE a.pdt_ID = p_pqvv_rec.pdt_id
649: AND b.id = c.pqy_id
650: AND c.id = p_pqvv_rec.qve_id

Line 657: okl_pdt_qualitys_v b,

653: ELSIF csr_rec.name = 'TAXOWNER' AND csr_rec.value = 'LESSOR' THEN
654: SELECT COUNT(b.id)
655: INTO l_leaseop_lessee_mismatch
656: FROM OKL_pdt_pqy_vals_V a,
657: okl_pdt_qualitys_v b,
658: okl_pqy_values_v c
659: WHERE a.pdt_ID = p_pqvv_rec.pdt_id
660: AND b.id = c.pqy_id
661: AND c.id = p_pqvv_rec.qve_id