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 1697: from okl_lease_applications_b LAP, OKL_FEES_B FEE, OKL_CASH_FLOW_OBJECTS,

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

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

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

Line 1802: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_FEES_B'

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

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

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

Line 1897: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_FEES_B'

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

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

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

Line 1993: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_FEES_B'

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

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

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

Line 2089: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_FEES_B'

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

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

2292: and CFO.SOURCE_TABLE = 'OKL_ASSETS_B';
2293:
2294: /*union
2295: select OKL_CASH_FLOW_LEVELS.start_date end_date
2296: from okl_lease_applications_b LAP, OKL_FEES_B FEE, OKL_CASH_FLOW_OBJECTS,
2297: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
2298: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_FEE'
2299: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
2300: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID

Line 2302: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_FEES_B'

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

Line 2442: OKL_FEES_B FEES, OKL_STRM_TMPT_PRIMARY_UV STRM

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

Line 2453: OKL_FEES_B FEES, OKL_STRM_TYPE_V STRM

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

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

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

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

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

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

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

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

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

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

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