[Home] [Help]
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
431: WHERE ADJ.ADJUSTMENT_SOURCE_TYPE = 'SUBSIDY'
432: AND ADJ.PARENT_OBJECT_CODE = 'ASSET'
433: AND ADJ.ADJUSTMENT_SOURCE_ID = SUB.ID
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,
540: OKL_LEASE_APPLICATIONS_B LAP
541: WHERE ADJ.ADJUSTMENT_SOURCE_TYPE = 'SUBSIDY'
542: AND ADJ.PARENT_OBJECT_CODE = 'ASSET'
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,
572: OKL_LEASE_APPLICATIONS_B LAP
573: WHERE ADJ.ADJUSTMENT_SOURCE_TYPE = 'SUBSIDY'
574: AND ADJ.PARENT_OBJECT_CODE = 'ASSET'
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
705: WHERE ADJ.ADJUSTMENT_SOURCE_TYPE = 'SUBSIDY'
706: AND ADJ.PARENT_OBJECT_CODE = 'ASSET'
707: AND ADJ.ADJUSTMENT_SOURCE_ID = SUB.ID
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
827: WHERE ADJ.ADJUSTMENT_SOURCE_TYPE = 'SUBSIDY'
828: AND ADJ.PARENT_OBJECT_CODE = 'ASSET'
829: AND ADJ.ADJUSTMENT_SOURCE_ID = SUB.ID
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
852: WHERE ADJ.ADJUSTMENT_SOURCE_TYPE = 'SUBSIDY'
853: AND ADJ.PARENT_OBJECT_CODE = 'ASSET'
854: AND ADJ.ADJUSTMENT_SOURCE_ID = SUB.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
875: WHERE ADJ.ADJUSTMENT_SOURCE_TYPE = 'SUBSIDY'
876: AND ADJ.PARENT_OBJECT_CODE = 'ASSET'
877: AND ADJ.ADJUSTMENT_SOURCE_ID = SUB.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
1061: WHERE ADJ.ADJUSTMENT_SOURCE_TYPE = 'SUBSIDY'
1062: AND ADJ.PARENT_OBJECT_CODE = 'ASSET'
1063: AND ADJ.ADJUSTMENT_SOURCE_ID = SUB.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
1186: WHERE ADJ.ADJUSTMENT_SOURCE_TYPE = 'SUBSIDY'
1187: AND ADJ.PARENT_OBJECT_CODE = 'ASSET'
1188: AND ADJ.ADJUSTMENT_SOURCE_ID = SUB.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
1312: WHERE ADJ.ADJUSTMENT_SOURCE_TYPE = 'SUBSIDY'
1313: AND ADJ.PARENT_OBJECT_CODE = 'ASSET'
1314: AND ADJ.ADJUSTMENT_SOURCE_ID = SUB.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
1554: WHERE ADJ.ADJUSTMENT_SOURCE_TYPE = 'SUBSIDY'
1555: AND ADJ.PARENT_OBJECT_CODE = 'ASSET'
1556: AND ADJ.ADJUSTMENT_SOURCE_ID = SUB.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
1853: WHERE ADJ.ADJUSTMENT_SOURCE_TYPE = 'SUBSIDY'
1854: AND ADJ.PARENT_OBJECT_CODE = 'ASSET'
1855: AND ADJ.ADJUSTMENT_SOURCE_ID = SUB.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
2107: WHERE ADJ.ADJUSTMENT_SOURCE_TYPE = 'SUBSIDY'
2108: AND ADJ.PARENT_OBJECT_CODE = 'ASSET'
2109: AND ADJ.ADJUSTMENT_SOURCE_ID = SUB.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
2234: WHERE ADJ.ADJUSTMENT_SOURCE_TYPE = 'SUBSIDY'
2235: AND ADJ.PARENT_OBJECT_CODE = 'ASSET'
2236: AND ADJ.ADJUSTMENT_SOURCE_ID = SUB.ID
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
2490: WHERE ADJ.ADJUSTMENT_SOURCE_TYPE = 'SUBSIDY'
2491: AND ADJ.PARENT_OBJECT_CODE = 'ASSET'
2492: AND ADJ.ADJUSTMENT_SOURCE_ID = SUB.ID
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
2515: WHERE ADJ.ADJUSTMENT_SOURCE_TYPE = 'SUBSIDY'
2516: AND ADJ.PARENT_OBJECT_CODE = 'ASSET'
2517: AND ADJ.ADJUSTMENT_SOURCE_ID = SUB.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
2538: WHERE ADJ.ADJUSTMENT_SOURCE_TYPE = 'SUBSIDY'
2539: AND ADJ.PARENT_OBJECT_CODE = 'ASSET'
2540: AND ADJ.ADJUSTMENT_SOURCE_ID = SUB.ID