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_LEASE_QUOTE_SUBPOOL_PVT dependencies on OKL_COST_ADJUSTMENTS_B

Line 426: FROM OKL_COST_ADJUSTMENTS_B ADJ,

422: CURSOR c_get_quote_subpool_usage IS
423: SELECT SUB.SUBSIDY_POOL_ID SUBSIDY_POOL_ID,
424: SUM(DECODE(ADJ.VALUE, NULL, ADJ.DEFAULT_SUBSIDY_AMOUNT, ADJ.VALUE)) AMOUNT,
425: QUOTE.ID QUOTE_ID
426: FROM OKL_COST_ADJUSTMENTS_B ADJ,
427: OKL_SUBSIDIES_B SUB,
428: OKL_SUBSIDY_POOLS_B SUB_POOL,
429: OKL_ASSETS_B ASSET,
430: OKL_LEASE_QUOTES_B QUOTE

Line 535: FROM OKL_COST_ADJUSTMENTS_B ADJ,

531: CURSOR c_get_quote_subpool_usage(p_qte_id IN NUMBER) IS
532: SELECT SUB.SUBSIDY_POOL_ID SUBSIDY_POOL_ID,
533: SUM(DECODE(ADJ.VALUE, NULL, ADJ.DEFAULT_SUBSIDY_AMOUNT, ADJ.VALUE)) AMOUNT,
534: QUOTE.ID QUOTE_ID
535: FROM OKL_COST_ADJUSTMENTS_B ADJ,
536: OKL_SUBSIDIES_B SUB,
537: OKL_SUBSIDY_POOLS_B SUB_POOL,
538: OKL_ASSETS_B ASSET,
539: OKL_LEASE_QUOTES_V QUOTE,

Line 567: FROM OKL_COST_ADJUSTMENTS_B ADJ,

563: CURSOR c_wd_get_quote_subpool_usage(p_qte_id IN NUMBER) IS
564: SELECT SUB.SUBSIDY_POOL_ID SUBSIDY_POOL_ID,
565: SUM(DECODE(ADJ.VALUE, NULL, ADJ.DEFAULT_SUBSIDY_AMOUNT, ADJ.VALUE)) AMOUNT,
566: QUOTE.ID QUOTE_ID
567: FROM OKL_COST_ADJUSTMENTS_B ADJ,
568: OKL_SUBSIDIES_B SUB,
569: OKL_SUBSIDY_POOLS_B SUB_POOL,
570: OKL_ASSETS_B ASSET,
571: OKL_LEASE_QUOTES_V QUOTE,

Line 700: FROM OKL_COST_ADJUSTMENTS_B ADJ,

696: SUB.CURRENCY_CODE SUB_CURRENCY_CODE,
697: SUB_POOL.CURRENCY_CODE SUBPOOL_CURRENCY_CODE,
698: -- SUB_POOL.CURRENCY_CONVERSION_TYPE,
699: SUB_POOL.TOTAL_SUBSIDY_AMOUNT
700: FROM OKL_COST_ADJUSTMENTS_B ADJ,
701: OKL_SUBSIDIES_B SUB,
702: OKL_SUBSIDY_POOLS_B SUB_POOL,
703: OKL_ASSETS_B ASSET,
704: OKL_LEASE_QUOTES_B QUOTE

Line 822: FROM OKL_COST_ADJUSTMENTS_B ADJ,

818: FROM
819: (SELECT SUB.SUBSIDY_POOL_ID SUBSIDY_POOL_ID,
820: SUM(DECODE(ADJ.VALUE, NULL, ADJ.DEFAULT_SUBSIDY_AMOUNT, ADJ.VALUE)) AMOUNT,
821: QUOTE.ID QUOTE_ID
822: FROM OKL_COST_ADJUSTMENTS_B ADJ,
823: OKL_SUBSIDIES_B SUB,
824: OKL_SUBSIDY_POOLS_B SUB_POOL,
825: OKL_ASSETS_B ASSET,
826: OKL_LEASE_QUOTES_B QUOTE

Line 847: FROM OKL_COST_ADJUSTMENTS_B ADJ,

843: FROM
844: (SELECT SUB.SUBSIDY_POOL_ID SUBSIDY_POOL_ID,
845: SUM(DECODE(ADJ.VALUE, NULL, ADJ.DEFAULT_SUBSIDY_AMOUNT, ADJ.VALUE)) AMOUNT,
846: QUOTE.ID QUOTE_ID
847: FROM OKL_COST_ADJUSTMENTS_B ADJ,
848: OKL_SUBSIDIES_B SUB,
849: OKL_SUBSIDY_POOLS_B SUB_POOL,
850: OKL_ASSETS_B ASSET,
851: OKL_LEASE_QUOTES_B QUOTE

Line 870: FROM OKL_COST_ADJUSTMENTS_B ADJ,

866:
867: CURSOR c_get_quote_pool_values IS
868: SELECT SUB.SUBSIDY_POOL_ID SUBSIDY_POOL_ID,
869: SUM(DECODE(ADJ.VALUE, NULL, ADJ.DEFAULT_SUBSIDY_AMOUNT, ADJ.VALUE)) AMOUNT
870: FROM OKL_COST_ADJUSTMENTS_B ADJ,
871: OKL_SUBSIDIES_B SUB,
872: OKL_SUBSIDY_POOLS_B SUB_POOL,
873: OKL_ASSETS_B ASSET,
874: OKL_LEASE_QUOTES_B QUOTE

Line 1056: FROM OKL_COST_ADJUSTMENTS_B ADJ,

1052:
1053: CURSOR c_get_leaseopp_pool_values IS
1054: SELECT SUB.SUBSIDY_POOL_ID SUBSIDY_POOL_ID,
1055: QUOTE.ID QUOTE_ID
1056: FROM OKL_COST_ADJUSTMENTS_B ADJ,
1057: OKL_SUBSIDIES_B SUB,
1058: OKL_SUBSIDY_POOLS_B SUB_POOL,
1059: OKL_ASSETS_B ASSET,
1060: OKL_LEASE_QUOTES_B QUOTE

Line 1181: FROM OKL_COST_ADJUSTMENTS_B ADJ,

1177:
1178: CURSOR c_get_leaseopp_pool_values IS
1179: SELECT SUB.SUBSIDY_POOL_ID SUBSIDY_POOL_ID,
1180: QUOTE.ID QUOTE_ID
1181: FROM OKL_COST_ADJUSTMENTS_B ADJ,
1182: OKL_SUBSIDIES_B SUB,
1183: OKL_SUBSIDY_POOLS_B SUB_POOL,
1184: OKL_ASSETS_B ASSET,
1185: OKL_LEASE_QUOTES_B QUOTE

Line 1307: FROM OKL_COST_ADJUSTMENTS_B ADJ,

1303:
1304: CURSOR c_get_leaseapp_pool_values IS
1305: SELECT SUB.SUBSIDY_POOL_ID SUBSIDY_POOL_ID,
1306: QUOTE.ID QUOTE_ID
1307: FROM OKL_COST_ADJUSTMENTS_B ADJ,
1308: OKL_SUBSIDIES_B SUB,
1309: OKL_SUBSIDY_POOLS_B SUB_POOL,
1310: OKL_ASSETS_B ASSET,
1311: OKL_LEASE_QUOTES_B QUOTE

Line 1549: FROM OKL_COST_ADJUSTMENTS_B ADJ,

1545: CURSOR c_get_leaseapp_pool_values IS
1546: SELECT SUB.SUBSIDY_POOL_ID SUBSIDY_POOL_ID,
1547: QUOTE.ID QUOTE_ID,
1548: SUM(DECODE(ADJ.VALUE, NULL, ADJ.DEFAULT_SUBSIDY_AMOUNT, ADJ.VALUE)) AMOUNT
1549: FROM OKL_COST_ADJUSTMENTS_B ADJ,
1550: OKL_SUBSIDIES_B SUB,
1551: OKL_SUBSIDY_POOLS_B SUB_POOL,
1552: OKL_ASSETS_B ASSET,
1553: OKL_LEASE_QUOTES_B QUOTE

Line 1848: FROM OKL_COST_ADJUSTMENTS_B ADJ,

1844:
1845: CURSOR c_get_leaseapp_pool_values IS
1846: SELECT SUB.SUBSIDY_POOL_ID SUBSIDY_POOL_ID,
1847: QUOTE.ID QUOTE_ID
1848: FROM OKL_COST_ADJUSTMENTS_B ADJ,
1849: OKL_SUBSIDIES_B SUB,
1850: OKL_SUBSIDY_POOLS_B SUB_POOL,
1851: OKL_ASSETS_B ASSET,
1852: OKL_LEASE_QUOTES_B QUOTE

Line 2102: FROM OKL_COST_ADJUSTMENTS_B ADJ,

2098:
2099: CURSOR c_get_leaseapp_pool_values IS
2100: SELECT SUB.SUBSIDY_POOL_ID SUBSIDY_POOL_ID,
2101: QUOTE.ID QUOTE_ID
2102: FROM OKL_COST_ADJUSTMENTS_B ADJ,
2103: OKL_SUBSIDIES_B SUB,
2104: OKL_SUBSIDY_POOLS_B SUB_POOL,
2105: OKL_ASSETS_B ASSET,
2106: OKL_LEASE_QUOTES_B QUOTE

Line 2229: FROM OKL_COST_ADJUSTMENTS_B ADJ,

2225:
2226: CURSOR c_get_leaseapp_pool_values(p_lap_quote_id IN NUMBER) IS
2227: SELECT SUB.SUBSIDY_POOL_ID SUBSIDY_POOL_ID,
2228: QUOTE.ID QUOTE_ID
2229: FROM OKL_COST_ADJUSTMENTS_B ADJ,
2230: OKL_SUBSIDIES_B SUB,
2231: OKL_SUBSIDY_POOLS_B SUB_POOL,
2232: OKL_ASSETS_B ASSET,
2233: OKL_LEASE_QUOTES_B QUOTE

Line 2485: FROM OKL_COST_ADJUSTMENTS_B ADJ,

2481: FROM
2482: (SELECT SUB.SUBSIDY_POOL_ID SUBSIDY_POOL_ID,
2483: SUM(DECODE(ADJ.VALUE, NULL, ADJ.DEFAULT_SUBSIDY_AMOUNT, ADJ.VALUE)) AMOUNT,
2484: QUOTE.ID QUOTE_ID
2485: FROM OKL_COST_ADJUSTMENTS_B ADJ,
2486: OKL_SUBSIDIES_B SUB,
2487: OKL_SUBSIDY_POOLS_B SUB_POOL,
2488: OKL_ASSETS_B ASSET,
2489: OKL_LEASE_QUOTES_B QUOTE

Line 2510: FROM OKL_COST_ADJUSTMENTS_B ADJ,

2506: FROM
2507: (SELECT SUB.SUBSIDY_POOL_ID SUBSIDY_POOL_ID,
2508: SUM(DECODE(ADJ.VALUE, NULL, ADJ.DEFAULT_SUBSIDY_AMOUNT, ADJ.VALUE)) AMOUNT,
2509: QUOTE.ID QUOTE_ID
2510: FROM OKL_COST_ADJUSTMENTS_B ADJ,
2511: OKL_SUBSIDIES_B SUB,
2512: OKL_SUBSIDY_POOLS_B SUB_POOL,
2513: OKL_ASSETS_B ASSET,
2514: OKL_LEASE_QUOTES_B QUOTE

Line 2533: FROM OKL_COST_ADJUSTMENTS_B ADJ,

2529:
2530: CURSOR c_get_quote_pool_values IS
2531: SELECT SUB.SUBSIDY_POOL_ID SUBSIDY_POOL_ID,
2532: SUM(DECODE(ADJ.VALUE, NULL, ADJ.DEFAULT_SUBSIDY_AMOUNT, ADJ.VALUE)) AMOUNT
2533: FROM OKL_COST_ADJUSTMENTS_B ADJ,
2534: OKL_SUBSIDIES_B SUB,
2535: OKL_SUBSIDY_POOLS_B SUB_POOL,
2536: OKL_ASSETS_B ASSET,
2537: OKL_LEASE_QUOTES_B QUOTE