DBA Data[Home] [Help]

APPS.OKL_ISG_UTILS_PVT dependencies on OKL_PRODUCTS_V

Line 38: okl_products_v pdt

34: khr.deal_type,
35: nvl(pdt.reporting_pdt_id, -1) report_pdt_id
36: FROM okc_k_headers_v chr,
37: okl_k_headers khr,
38: okl_products_v pdt
39: WHERE khr.id = chr.id
40: AND chr.id = l_khr_id
41: AND khr.pdt_id = pdt.id(+);
42:

Line 52: OKL_PRODUCTS_V PDT,

48: OKL_ST_GEN_TMPT_LNS TLN,
49: OKL_ST_GEN_TEMPLATES TMPT,
50: OKL_ST_GEN_TMPT_SETS Tst,
51: OKL_AE_TMPT_SETS AES,
52: OKL_PRODUCTS_V PDT,
53: OKL_STRM_TYPE_v STY
54:
55: WHERE
56: TLN.GTT_ID = TMPT.ID AND

Line 156: okl_products_v pdt

152: khr.deal_type,
153: nvl(pdt.reporting_pdt_id, -1) report_pdt_id
154: FROM okc_k_headers_v chr,
155: okl_k_headers khr,
156: okl_products_v pdt
157: WHERE khr.id = chr.id
158: AND chr.id = l_khr_id
159: AND khr.pdt_id = pdt.id(+);
160:

Line 170: OKL_PRODUCTS_V PDT,

166: OKL_ST_GEN_TMPT_LNS TLN,
167: OKL_ST_GEN_TEMPLATES TMPT,
168: OKL_ST_GEN_TMPT_SETS Tst,
169: OKL_AE_TMPT_SETS AES,
170: OKL_PRODUCTS_V PDT,
171: OKL_STRM_TYPE_v STY
172:
173: WHERE
174: TLN.GTT_ID = TMPT.ID AND

Line 284: okl_products_v pdt

280: khr.deal_type,
281: nvl(pdt.reporting_pdt_id, -1) report_pdt_id
282: FROM okc_k_headers_v chr,
283: okl_k_headers khr,
284: okl_products_v pdt
285: WHERE khr.id = chr.id
286: AND chr.id = l_khr_id
287: AND khr.pdt_id = pdt.id(+);
288:

Line 298: OKL_PRODUCTS_V PDT,

294: OKL_ST_GEN_TMPT_LNS TLN,
295: OKL_ST_GEN_TEMPLATES TMPT,
296: OKL_ST_GEN_TMPT_SETS Tst,
297: OKL_AE_TMPT_SETS AES,
298: OKL_PRODUCTS_V PDT,
299: OKL_STRM_TYPE_v STY
300: , OKL_STRM_TYPE_v STY1
301: WHERE
302: TLN.GTT_ID = TMPT.ID AND

Line 421: okl_products_v pdt

417: khr.deal_type,
418: nvl(pdt.reporting_pdt_id, -1) report_pdt_id
419: FROM okc_k_headers_v chr,
420: okl_k_headers khr,
421: okl_products_v pdt
422: WHERE khr.id = chr.id
423: AND chr.id = l_khr_id
424: AND khr.pdt_id = pdt.id(+);
425:

Line 435: OKL_PRODUCTS_V PDT,

431: OKL_ST_GEN_TMPT_LNS TLN,
432: OKL_ST_GEN_TEMPLATES TMPT,
433: OKL_ST_GEN_TMPT_SETS Tst,
434: OKL_AE_TMPT_SETS AES,
435: OKL_PRODUCTS_V PDT,
436: OKL_STRM_TYPE_v STY
437: , OKL_STRM_TYPE_v STY1
438: WHERE
439: TLN.GTT_ID = TMPT.ID AND

Line 1276: OKL_PRODUCTS_V PDT,

1272: OKL_ST_GEN_TMPT_LNS TLN,
1273: OKL_ST_GEN_TEMPLATES TMPT,
1274: OKL_ST_GEN_TMPT_SETS Tst,
1275: OKL_AE_TMPT_SETS AES,
1276: OKL_PRODUCTS_V PDT,
1277: OKL_STRM_TYPE_v STY
1278: , OKL_STRM_TYPE_v STY1
1279: WHERE
1280: TLN.GTT_ID = TMPT.ID AND

Line 1392: OKL_PRODUCTS_V PDT,

1388: OKL_ST_GEN_TMPT_LNS TLN,
1389: OKL_ST_GEN_TEMPLATES TMPT,
1390: OKL_ST_GEN_TMPT_SETS Tst,
1391: OKL_AE_TMPT_SETS AES,
1392: OKL_PRODUCTS_V PDT,
1393: OKL_STRM_TYPE_v STY
1394: , OKL_STRM_TYPE_v STY1
1395: WHERE
1396: TLN.GTT_ID = TMPT.ID AND

Line 1502: OKL_PRODUCTS_V PDT,

1498: OKL_ST_GEN_TMPT_LNS TLN,
1499: OKL_ST_GEN_TEMPLATES TMPT,
1500: OKL_ST_GEN_TMPT_SETS Tst,
1501: OKL_AE_TMPT_SETS AES,
1502: OKL_PRODUCTS_V PDT,
1503: OKL_STRM_TYPE_v STY
1504: , OKL_STRM_TYPE_v STY1
1505: WHERE
1506: TLN.GTT_ID = TMPT.ID AND

Line 1633: okl_products_v pdt,

1629: tst.isg_arrears_pay_dates_option
1630: FROM
1631: okl_st_gen_tmpt_sets tst,
1632: okl_ae_tmpt_sets_all aes,
1633: okl_products_v pdt,
1634: okl_k_headers khr
1635: WHERE
1636: khr.id = p_khr_id
1637: AND pdt.id = khr.pdt_id