APPS.OKL_SETUPPRODUCTS_PVT dependencies on OKL_PDT_PQYS_V

Line 393: okl_pdt_pqys_v pdq

389: CURSOR choose_qlty_csr(cp_ptl_id okl_pdt_templates_v.id%TYPE) IS
390: SELECT DISTINCT pqy.id id,
391: pqy.name name
392: FROM okl_pdt_qualitys_v pqy,
393: okl_pdt_pqys_v pdq
394: WHERE pqy.id = pdq.pqy_id
395: AND pdq.ptl_id = cp_ptl_id
396:
397: AND pqy.name IN ('LEASE','INVESTOR','TAXOWNER');

Line 560: okl_pdt_pqys_v pdq

556: SELECT COUNT(pqy.id)
557: INTO l_invalid_product_cnt
558: FROM
559: okl_pdt_qualitys_v pqy,
560: okl_pdt_pqys_v pdq
561: where pqy.id = pdq.pqy_id
562: AND pdq.ptl_id = p_pdtv_rec.ptl_id
563: AND pqy.name = 'INVESTOR';
564:

Line 582: okl_pdt_pqys_v pdq

578: SELECT COUNT(pqy.id)
579: INTO l_quality_miss_cnt
580: FROM
581: okl_pdt_qualitys_v pqy,
582: okl_pdt_pqys_v pdq
583: WHERE pqy.id = pdq.pqy_id
584: AND pdq.ptl_id = p_pdtv_rec.ptl_id
585: AND pqy.name IN ('LEASE','INVESTOR','TAXOWNER');
586:

Line 608: okl_pdt_pqys_v pdq,

604:
605: INTO l_pdt_ptl_changed
606: FROM okl_pqy_values_v qve,
607: okl_pdt_qualitys pqy,
608: okl_pdt_pqys_v pdq,
609: okl_pdt_pqy_vals pqv
610: WHERE qve.pqy_id = pqy.id
611: AND pqv.qve_id = qve.id
612: AND pqv.pdq_id = pdq.id

Line 1928: FROM okl_PDT_PQYS_V PDQ,

1924: WHERE b.gts_id = c.id
1925: AND b.id = p_aes_id
1926: INTERSECT
1927: SELECT DISTINCT PQY.NAME
1928: FROM okl_PDT_PQYS_V PDQ,
1929: OKL_PQY_VALUES_V QVE,OKL_PDT_QUALITYS_V PQY
1930: WHERE PQY.ID = QVE.PQY_ID
1931: AND PQY.ID= PDQ.PQY_ID
1932: AND PDQ.PTL_ID = p_PTL_ID

Line 3941: FROM okl_PDT_PQYS_V PDQ,

3937: WHERE b.gts_id = c.id
3938: AND b.id = p_aes_id
3939: INTERSECT
3940: SELECT DISTINCT PQY.NAME
3941: FROM okl_PDT_PQYS_V PDQ,
3942: OKL_PQY_VALUES_V QVE,OKL_PDT_QUALITYS_V PQY
3943: WHERE PQY.ID = QVE.PQY_ID
3944: AND PQY.ID= PDQ.PQY_ID
3945: AND PDQ.PTL_ID = p_PTL_ID

Line 4139: FROM okl_PDT_PQYS_V PDQ,

4135: WHERE b.gts_id = c.id
4136: AND b.id = p_aes_id
4137: INTERSECT
4138: SELECT DISTINCT PQY.NAME
4139: FROM okl_PDT_PQYS_V PDQ,
4140: OKL_PQY_VALUES_V QVE,OKL_PDT_QUALITYS_V PQY
4141: WHERE PQY.ID = QVE.PQY_ID
4142: AND PQY.ID= PDQ.PQY_ID
4143: AND PDQ.PTL_ID = p_PTL_ID