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_PQY_VALUES_V

Line 181: FROM Okl_Pqy_Values_V qve

177: p_from_date IN Okl_Pdt_Pqy_Vals_V.FROM_DATE%TYPE,
178: p_to_date IN Okl_Pdt_Pqy_Vals_V.TO_DATE%TYPE
179: ) IS
180: SELECT '1'
181: FROM Okl_Pqy_Values_V qve
182: WHERE qve.ID = p_qve_id
183: AND ((qve.FROM_DATE > p_from_date OR
184: p_from_date > NVL(qve.TO_DATE,p_from_date)) OR
185: NVL(qve.TO_DATE, p_to_date) < p_to_date);

Line 200: okl_pqy_values_v qve,

196: IS
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

Line 213: okl_pqy_values_v qve,

209: IS
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

Line 546: okl_pqy_values_v c

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
550: AND c.value = 'LESSEE'

Line 557: okl_pqy_values_v c

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
561: AND c.value = 'LEASEOP'

Line 570: okl_pqy_values_v c

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
574: AND c.value = 'LOAN-REVOLVING'

Line 581: okl_pqy_values_v c

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
585: AND c.value = 'FLOAT_FACTORS'

Line 595: okl_pqy_values_v c

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
599: AND c.value = 'FLOAT_FACTORS'

Line 606: okl_pqy_values_v c

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
610: AND c.value = 'ESTIMATED_AND_BILLED'

Line 621: okl_pqy_values_v c

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
625: AND c.value = 'LESSOR'

Line 633: okl_pqy_values_v c

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
637: AND c.value = 'LOAN'

Line 647: okl_pqy_values_v c

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
651: AND c.value = 'LESSOR'

Line 658: okl_pqy_values_v c

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
662: AND c.value = 'LOAN-REVOLVING'

Line 805: FROM okl_pqy_values_v

801: ,x_return_status OUT NOCOPY VARCHAR2)
802: IS
803: CURSOR okl_qvev_pk_csr (p_id IN NUMBER) IS
804: SELECT '1'
805: FROM okl_pqy_values_v
806: WHERE okl_pqy_values_v.id = p_id;
807:
808: l_qve_status VARCHAR2(1);
809: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 806: WHERE okl_pqy_values_v.id = p_id;

802: IS
803: CURSOR okl_qvev_pk_csr (p_id IN NUMBER) IS
804: SELECT '1'
805: FROM okl_pqy_values_v
806: WHERE okl_pqy_values_v.id = p_id;
807:
808: l_qve_status VARCHAR2(1);
809: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
810: l_row_notfound BOOLEAN := TRUE;