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_CREDIT_DATAPOINTS_PVT dependencies on OKL_FEES_B

Line 1699: from okl_lease_applications_b LAP, OKL_FEES_B FEE, OKL_CASH_FLOW_OBJECTS,

1695: AND FND.LOOKUP_TYPE = 'OKL_FREQUENCY';
1696:
1697: /*UNION
1698: select OKL_CASH_FLOW_LEVELS.FQY_CODE FQY_CODE
1699: from okl_lease_applications_b LAP, OKL_FEES_B FEE, OKL_CASH_FLOW_OBJECTS,
1700: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
1701: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_FEE'
1702: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
1703: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID

Line 1799: from okl_lease_applications_b LAP, OKL_FEES_B FEE, OKL_CASH_FLOW_OBJECTS,

1795: AND FND.LOOKUP_TYPE = 'OKL_YES_NO';
1796:
1797: /*union
1798: select OKL_CASH_FLOWS.due_arrears_yn due_arrears_yn
1799: from okl_lease_applications_b LAP, OKL_FEES_B FEE, OKL_CASH_FLOW_OBJECTS,
1800: okl_cash_flows, OKL_LEASE_QUOTES_B QUOTE
1801: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_FEE'
1802: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
1803: and OKL_CASH_FLOW_OBJECTS.source_id = FEE.id

Line 1804: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_FEES_B'

1800: okl_cash_flows, OKL_LEASE_QUOTES_B QUOTE
1801: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_FEE'
1802: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
1803: and OKL_CASH_FLOW_OBJECTS.source_id = FEE.id
1804: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_FEES_B'
1805: and FEE.parent_object_id = QUOTE.id
1806: and QUOTE.parent_object_id = LAP.id
1807: and FEE.parent_object_code = 'LEASEQUOTE'
1808: and QUOTE.parent_object_code = 'LEASEAPP'

Line 1893: from okl_lease_applications_b LAP, OKL_FEES_B FEE, OKL_CASH_FLOW_OBJECTS,

1889: and CFO.SOURCE_TABLE = 'OKL_ASSETS_B';
1890:
1891: /*union
1892: select OKL_CASH_FLOW_LEVELS.number_of_periods number_of_periods
1893: from okl_lease_applications_b LAP, OKL_FEES_B FEE, OKL_CASH_FLOW_OBJECTS,
1894: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
1895: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_FEE'
1896: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
1897: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID

Line 1899: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_FEES_B'

1895: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_FEE'
1896: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
1897: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
1898: and OKL_CASH_FLOW_OBJECTS.source_id = FEE.id
1899: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_FEES_B'
1900: and FEE.parent_object_id = QUOTE.id
1901: and QUOTE.parent_object_id = LAP.id
1902: and FEE.parent_object_code = 'LEASEQUOTE'
1903: and QUOTE.parent_object_code = 'LEASEAPP'

Line 1989: from okl_lease_applications_b LAP, OKL_FEES_B FEE, OKL_CASH_FLOW_OBJECTS,

1985: and CFO.SOURCE_TABLE = 'OKL_ASSETS_B';
1986:
1987: /*union
1988: select OKL_CASH_FLOW_LEVELS.amount amount
1989: from okl_lease_applications_b LAP, OKL_FEES_B FEE, OKL_CASH_FLOW_OBJECTS,
1990: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
1991: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_FEE'
1992: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
1993: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID

Line 1995: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_FEES_B'

1991: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_FEE'
1992: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
1993: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
1994: and OKL_CASH_FLOW_OBJECTS.source_id = FEE.id
1995: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_FEES_B'
1996: and FEE.parent_object_id = QUOTE.id
1997: and QUOTE.parent_object_id = LAP.id
1998: and FEE.parent_object_code = 'LEASEQUOTE'
1999: and QUOTE.parent_object_code = 'LEASEAPP'

Line 2085: from okl_lease_applications_b LAP, OKL_FEES_B FEE, OKL_CASH_FLOW_OBJECTS,

2081: and CFO.SOURCE_TABLE = 'OKL_ASSETS_B';
2082:
2083: /*union
2084: select OKL_CASH_FLOW_LEVELS.start_date start_date
2085: from okl_lease_applications_b LAP, OKL_FEES_B FEE, OKL_CASH_FLOW_OBJECTS,
2086: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
2087: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_FEE'
2088: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
2089: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID

Line 2091: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_FEES_B'

2087: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_FEE'
2088: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
2089: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
2090: and OKL_CASH_FLOW_OBJECTS.source_id = FEE.id
2091: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_FEES_B'
2092: and FEE.parent_object_id = QUOTE.id
2093: and QUOTE.parent_object_id = LAP.id
2094: and FEE.parent_object_code = 'LEASEQUOTE'
2095: and QUOTE.parent_object_code = 'LEASEAPP'

Line 2299: from okl_lease_applications_b LAP, OKL_FEES_B FEE, OKL_CASH_FLOW_OBJECTS,

2295: order by LVL.start_date; --Bug # 9116306
2296:
2297: /*union
2298: select OKL_CASH_FLOW_LEVELS.start_date end_date
2299: from okl_lease_applications_b LAP, OKL_FEES_B FEE, OKL_CASH_FLOW_OBJECTS,
2300: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
2301: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_FEE'
2302: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
2303: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID

Line 2305: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_FEES_B'

2301: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_FEE'
2302: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
2303: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
2304: and OKL_CASH_FLOW_OBJECTS.source_id = FEE.id
2305: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_FEES_B'
2306: and FEE.parent_object_id = QUOTE.id
2307: and QUOTE.parent_object_id = LAP.id
2308: and FEE.parent_object_code = 'LEASEQUOTE'
2309: and QUOTE.parent_object_code = 'LEASEAPP'

Line 2445: OKL_FEES_B FEES, OKL_STRM_TMPT_PRIMARY_UV STRM

2441: CURSOR cFeeName IS
2442: /*
2443: SELECT STRM.STY_NAME FEE_NAME
2444: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_LEASE_QUOTES_B QUOTE,
2445: OKL_FEES_B FEES, OKL_STRM_TMPT_PRIMARY_UV STRM
2446: WHERE STRM.STY_ID = FEES.STREAM_TYPE_ID
2447: AND FEES.PARENT_OBJECT_CODE = 'LEASEQUOTE'
2448: AND FEES.PARENT_OBJECT_ID = QUOTE.ID
2449: AND QUOTE.PARENT_OBJECT_ID = LAP.ID

Line 2456: OKL_FEES_B FEES, OKL_STRM_TYPE_V STRM

2452: AND LAP.ID = l_lease_app_id;
2453: */
2454: SELECT STRM.NAME FEE_NAME
2455: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_LEASE_QUOTES_B QUOTE,
2456: OKL_FEES_B FEES, OKL_STRM_TYPE_V STRM
2457: WHERE STRM.ID = FEES.STREAM_TYPE_ID
2458: AND FEES.PARENT_OBJECT_CODE = 'LEASEQUOTE'
2459: AND FEES.PARENT_OBJECT_ID = QUOTE.ID
2460: AND QUOTE.PARENT_OBJECT_ID = LAP.ID

Line 2510: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_LEASE_QUOTES_B QUOTE, OKL_FEES_B FEES

2506: l_fee_type VARCHAR2(30);
2507:
2508: CURSOR cFeeType IS
2509: SELECT FEES.FEE_TYPE FEE_TYPE
2510: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_LEASE_QUOTES_B QUOTE, OKL_FEES_B FEES
2511: WHERE FEES.PARENT_OBJECT_CODE = 'LEASEQUOTE'
2512: AND FEES.PARENT_OBJECT_ID = QUOTE.ID
2513: AND QUOTE.PARENT_OBJECT_ID = LAP.ID
2514: AND QUOTE.PARENT_OBJECT_CODE = 'LEASEAPP'

Line 2561: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_LEASE_QUOTES_B QUOTE, OKL_FEES_B FEES

2557: l_fee_amount NUMBER;
2558:
2559: CURSOR cFeeAmount IS
2560: SELECT FEES.FEE_AMOUNT FEE_AMOUNT
2561: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_LEASE_QUOTES_B QUOTE, OKL_FEES_B FEES
2562: WHERE FEES.PARENT_OBJECT_CODE = 'LEASEQUOTE'
2563: AND FEES.PARENT_OBJECT_ID = QUOTE.ID
2564: AND QUOTE.PARENT_OBJECT_ID = LAP.ID
2565: AND QUOTE.PARENT_OBJECT_CODE = 'LEASEAPP'

Line 2611: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_LEASE_QUOTES_B QUOTE, OKL_FEES_B FEES

2607: l_fee_date DATE;
2608:
2609: CURSOR cFeeEffFrom IS
2610: SELECT FEES.EFFECTIVE_FROM EFFECTIVE_FROM
2611: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_LEASE_QUOTES_B QUOTE, OKL_FEES_B FEES
2612: WHERE FEES.PARENT_OBJECT_CODE = 'LEASEQUOTE'
2613: AND FEES.PARENT_OBJECT_ID = QUOTE.ID
2614: AND QUOTE.PARENT_OBJECT_ID = LAP.ID
2615: AND QUOTE.PARENT_OBJECT_CODE = 'LEASEAPP'

Line 2714: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_LEASE_QUOTES_B QUOTE, OKL_FEES_B FEES

2710: AND LAP.ID = l_lease_app_id;*/
2711:
2712: SELECT NVL(SUM(FEES.FEE_AMOUNT), 0)
2713: INTO ln_fee_cost
2714: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_LEASE_QUOTES_B QUOTE, OKL_FEES_B FEES
2715: WHERE FEES.PARENT_OBJECT_CODE = 'LEASEQUOTE'
2716: AND FEES.PARENT_OBJECT_ID = QUOTE.ID
2717: AND FEES.FEE_TYPE IN ('ROLLOVER', 'FINANCED', 'CAPITALIZED') --Bug 6697231 Added capitalized fee
2718: AND QUOTE.PARENT_OBJECT_ID = LAP.ID

Line 2814: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_LEASE_QUOTES_B QUOTE, OKL_FEES_B FEES

2810: l_security_deposit VARCHAR2(120);
2811:
2812: CURSOR cSecDeposit IS
2813: SELECT FEES.FEE_AMOUNT FEE_AMOUNT
2814: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_LEASE_QUOTES_B QUOTE, OKL_FEES_B FEES
2815: WHERE FEES.PARENT_OBJECT_CODE = 'LEASEQUOTE'
2816: AND FEES.PARENT_OBJECT_ID = QUOTE.ID
2817: AND QUOTE.PARENT_OBJECT_ID = LAP.ID
2818: AND QUOTE.PARENT_OBJECT_CODE = 'LEASEAPP'