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_LEASE_QUOTES_B

Line 430: OKL_LEASE_QUOTES_B QUOTE

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
434: AND SUB.SUBSIDY_POOL_ID = SUB_POOL.ID

Line 704: OKL_LEASE_QUOTES_B QUOTE

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
708: AND SUB.SUBSIDY_POOL_ID = SUB_POOL.ID

Line 826: OKL_LEASE_QUOTES_B QUOTE

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
830: AND SUB.SUBSIDY_POOL_ID = SUB_POOL.ID

Line 851: OKL_LEASE_QUOTES_B QUOTE

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
855: AND SUB.SUBSIDY_POOL_ID = SUB_POOL.ID

Line 874: OKL_LEASE_QUOTES_B QUOTE

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
878: AND SUB.SUBSIDY_POOL_ID = SUB_POOL.ID

Line 1060: OKL_LEASE_QUOTES_B QUOTE

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
1064: AND SUB.SUBSIDY_POOL_ID = SUB_POOL.ID

Line 1185: OKL_LEASE_QUOTES_B QUOTE

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
1189: AND SUB.SUBSIDY_POOL_ID = SUB_POOL.ID

Line 1195: FROM OKL_LEASE_QUOTES_B

1191: AND ASSET.PARENT_OBJECT_CODE = 'LEASEQUOTE'
1192: AND ASSET.PARENT_OBJECT_ID = QUOTE.ID
1193: AND QUOTE.STATUS = 'PR-APPROVED'
1194: AND QUOTE.PARENT_OBJECT_ID = (SELECT PARENT_OBJECT_ID
1195: FROM OKL_LEASE_QUOTES_B
1196: WHERE ID = p_quote_id)
1197: GROUP BY SUB.SUBSIDY_POOL_ID, QUOTE.ID;
1198:
1199: ln_count NUMBER;

Line 1311: OKL_LEASE_QUOTES_B QUOTE

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
1315: AND SUB.SUBSIDY_POOL_ID = SUB_POOL.ID

Line 1325: FROM OKL_LEASE_QUOTES_B QUOTE,

1321: GROUP BY SUB.SUBSIDY_POOL_ID, QUOTE.ID;
1322:
1323: CURSOR c_get_leaseopp_quote_id(p_leaseapp_id IN NUMBER) IS
1324: SELECT QUOTE.ID
1325: FROM OKL_LEASE_QUOTES_B QUOTE,
1326: OKL_LEASE_OPPORTUNITIES_B LEASEOPP
1327: WHERE QUOTE.PARENT_OBJECT_ID = LEASEOPP.ID
1328: AND QUOTE.PARENT_OBJECT_CODE = 'LEASEOPP'
1329: AND QUOTE.STATUS = 'CT-ACCEPTED'

Line 1553: OKL_LEASE_QUOTES_B QUOTE

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
1557: AND SUB.SUBSIDY_POOL_ID = SUB_POOL.ID

Line 1852: OKL_LEASE_QUOTES_B QUOTE

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
1856: AND SUB.SUBSIDY_POOL_ID = SUB_POOL.ID

Line 2106: OKL_LEASE_QUOTES_B QUOTE

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
2110: AND SUB.SUBSIDY_POOL_ID = SUB_POOL.ID

Line 2233: OKL_LEASE_QUOTES_B QUOTE

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
2237: AND SUB.SUBSIDY_POOL_ID = SUB_POOL.ID

Line 2489: OKL_LEASE_QUOTES_B QUOTE

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
2493: AND SUB.SUBSIDY_POOL_ID = SUB_POOL.ID

Line 2514: OKL_LEASE_QUOTES_B QUOTE

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
2518: AND SUB.SUBSIDY_POOL_ID = SUB_POOL.ID

Line 2537: OKL_LEASE_QUOTES_B QUOTE

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
2541: AND SUB.SUBSIDY_POOL_ID = SUB_POOL.ID

Line 2582: FROM OKL_LEASE_QUOTES_B

2578: BEGIN
2579:
2580: SELECT REFERENCE_NUMBER, STATUS
2581: INTO lv_reference_number, lv_status_code
2582: FROM OKL_LEASE_QUOTES_B
2583: WHERE ID = p_quote_id;
2584: --debug_proc('Quote: '||lv_reference_number);
2585:
2586: IF (lv_status_code = 'PR-APPROVED') THEN

Line 2760: FROM okl_lease_quotes_b

2756: ln_parent_object_id NUMBER;
2757:
2758: CURSOR c_get_parent_object_info IS
2759: SELECT parent_object_id, parent_object_code
2760: FROM okl_lease_quotes_b
2761: WHERE id = p_quote_id;
2762:
2763: BEGIN
2764: