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_ASSETS_B

Line 508: OKL_LEASE_APPLICATIONS_B LAP, OKL_ASSETS_B ASSET,

504:
505: CURSOR citem IS
506: SELECT ITEM.CONCATENATED_SEGMENTS CONCATENATED_SEGMENTS, ASSET.ID
507: FROM MTL_SYSTEM_ITEMS_KFV ITEM, OKL_ASSET_COMPONENTS_B ASSET_COMP,
508: OKL_LEASE_APPLICATIONS_B LAP, OKL_ASSETS_B ASSET,
509: OKL_LEASE_QUOTES_B QUOTE
510: WHERE ITEM.INVENTORY_ITEM_ID = ASSET_COMP.INV_ITEM_ID
511: --Bug 7030452 :use inventory org id in the following condition
512: -- AND ITEM.ORGANIZATION_ID = LAP.ORG_ID -- ssdeshpa Bug # 6689249 added

Line 569: FROM OKL_ASSETS_TL ASSET_TL, OKL_ASSETS_B ASSET,

565: CURSOR citemdesc IS
566: -- ssdeshpa Bug#6689249 start
567: SELECT ASSET_TL.SHORT_DESCRIPTION DESCRIPTION
568: -- ssdeshpa Bug#6689249 end
569: FROM OKL_ASSETS_TL ASSET_TL, OKL_ASSETS_B ASSET,
570: OKL_LEASE_APPLICATIONS_B LAP, OKL_LEASE_QUOTES_B QUOTE
571: WHERE ASSET_TL.ID = ASSET.ID
572: AND ASSET.PARENT_OBJECT_ID = QUOTE.ID
573: AND QUOTE.PARENT_OBJECT_ID = LAP.ID

Line 626: OKL_LEASE_APPLICATIONS_B LAP, OKL_ASSETS_B ASSET,

622: -- ssdeshpa Bug# 6689249 start
623: SELECT VENDOR.VENDOR_NAME SUPPLIER
624: -- ssdeshpa Bug# 6689249 end
625: FROM PO_VENDORS VENDOR, OKL_ASSET_COMPONENTS_B ASSET_COMP,
626: OKL_LEASE_APPLICATIONS_B LAP, OKL_ASSETS_B ASSET,
627: OKL_LEASE_QUOTES_B QUOTE
628: WHERE VENDOR.VENDOR_ID = ASSET_COMP.SUPPLIER_ID
629: AND ASSET_COMP.ASSET_ID = ASSET.ID
630: AND ASSET_COMP.PRIMARY_COMPONENT = 'YES'

Line 681: OKL_ASSETS_B ASSET, OKL_LEASE_QUOTES_B QUOTE

677:
678: CURSOR cModelNum IS
679: SELECT ASSET_COMP.MODEL_NUMBER MODEL_NUMBER
680: FROM OKL_ASSET_COMPONENTS_B ASSET_COMP, OKL_LEASE_APPLICATIONS_B LAP,
681: OKL_ASSETS_B ASSET, OKL_LEASE_QUOTES_B QUOTE
682: WHERE ASSET_COMP.ASSET_ID = ASSET.ID
683: AND ASSET_COMP.PRIMARY_COMPONENT = 'YES'
684: AND ASSET.PARENT_OBJECT_ID = QUOTE.ID
685: AND QUOTE.PARENT_OBJECT_ID = LAP.ID

Line 736: OKL_ASSETS_B ASSET, OKL_LEASE_QUOTES_B QUOTE

732:
733: CURSOR cMfgName is
734: SELECT ASSET_COMP.MANUFACTURER_NAME MANUFACTURER_NAME
735: FROM OKL_ASSET_COMPONENTS_B ASSET_COMP, OKL_LEASE_APPLICATIONS_B LAP,
736: OKL_ASSETS_B ASSET, OKL_LEASE_QUOTES_B QUOTE
737: WHERE ASSET_COMP.ASSET_ID = ASSET.ID
738: AND ASSET_COMP.PRIMARY_COMPONENT = 'YES'
739: AND ASSET.PARENT_OBJECT_ID = QUOTE.ID
740: AND QUOTE.PARENT_OBJECT_ID = LAP.ID

Line 790: OKL_ASSETS_B ASSET, OKL_LEASE_QUOTES_B QUOTE

786:
787: CURSOR cYearMfg IS
788: SELECT ASSET_COMP.YEAR_MANUFACTURED YEAR_MANUFACTURED
789: FROM OKL_ASSET_COMPONENTS_B ASSET_COMP, OKL_LEASE_APPLICATIONS_B LAP,
790: OKL_ASSETS_B ASSET, OKL_LEASE_QUOTES_B QUOTE
791: WHERE ASSET_COMP.ASSET_ID = ASSET.ID
792: AND ASSET_COMP.PRIMARY_COMPONENT = 'YES'
793: AND ASSET.PARENT_OBJECT_ID = QUOTE.ID
794: AND QUOTE.PARENT_OBJECT_ID = LAP.ID

Line 843: OKL_ASSETS_B ASSET, OKL_LEASE_QUOTES_B QUOTE

839:
840: CURSOR cNoOfUnits IS
841: SELECT ASSET_COMP.NUMBER_OF_UNITS NUMBER_OF_UNITS
842: FROM OKL_ASSET_COMPONENTS_B ASSET_COMP, OKL_LEASE_APPLICATIONS_B LAP,
843: OKL_ASSETS_B ASSET, OKL_LEASE_QUOTES_B QUOTE
844: WHERE ASSET_COMP.ASSET_ID = ASSET.ID
845: AND ASSET_COMP.PRIMARY_COMPONENT = 'YES'
846: AND ASSET.PARENT_OBJECT_ID = QUOTE.ID
847: AND QUOTE.PARENT_OBJECT_ID = LAP.ID

Line 895: OKL_ASSETS_B ASSET, OKL_LEASE_QUOTES_B QUOTE

891:
892: CURSOR cUnitCost IS
893: SELECT ASSET_COMP.UNIT_COST UNIT_COST
894: FROM OKL_ASSET_COMPONENTS_B ASSET_COMP, OKL_LEASE_APPLICATIONS_B LAP,
895: OKL_ASSETS_B ASSET, OKL_LEASE_QUOTES_B QUOTE
896: WHERE ASSET_COMP.ASSET_ID = ASSET.ID
897: AND ASSET_COMP.PRIMARY_COMPONENT = 'YES'
898: AND ASSET.PARENT_OBJECT_ID = QUOTE.ID
899: AND QUOTE.PARENT_OBJECT_ID = LAP.ID

Line 949: OKL_ASSETS_B ASSET, OKL_LEASE_QUOTES_B QUOTE

945:
946: CURSOR cInstallSite IS
947: SELECT PARTY_SITE.PARTY_SITE_NUMBER PARTY_SITE_NUMBER
948: FROM HZ_PARTY_SITES PARTY_SITE, OKL_LEASE_APPLICATIONS_B LAP,
949: OKL_ASSETS_B ASSET, OKL_LEASE_QUOTES_B QUOTE
950: WHERE PARTY_SITE.PARTY_SITE_ID = ASSET.INSTALL_SITE_ID
951: AND ASSET.PARENT_OBJECT_ID = QUOTE.ID
952: AND QUOTE.PARENT_OBJECT_ID = LAP.ID
953: AND ASSET.PARENT_OBJECT_CODE = 'LEASEQUOTE'

Line 1458: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_ASSETS_B ASSET, OKL_LEASE_QUOTES_B QUOTE

1454: l_add_on_item_residual_values NUMBER;
1455:
1456: CURSOR cItemResVal IS
1457: SELECT NVL(ASSET.END_OF_TERM_VALUE,ASSET.END_OF_TERM_VALUE_DEFAULT) END_OF_TERM_VALUE
1458: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_ASSETS_B ASSET, OKL_LEASE_QUOTES_B QUOTE
1459: WHERE ASSET.PARENT_OBJECT_ID = QUOTE.ID
1460: AND QUOTE.PARENT_OBJECT_ID = LAP.ID
1461: AND ASSET.PARENT_OBJECT_CODE = 'LEASEQUOTE'
1462: AND QUOTE.PARENT_OBJECT_CODE = 'LEASEAPP'

Line 1512: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_ASSETS_B ASSET,

1508: x_resultout := FND_API.G_RET_STS_SUCCESS;
1509: BEGIN
1510: SELECT NVL(SUM(ADJ.VALUE), 0)
1511: INTO l_down_payment_amount
1512: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_ASSETS_B ASSET,
1513: OKL_COST_ADJUSTMENTS_B ADJ, OKL_LEASE_QUOTES_B QUOTE
1514: WHERE ADJ.ADJUSTMENT_SOURCE_TYPE = 'DOWN_PAYMENT'
1515: AND ADJ.PARENT_OBJECT_CODE = 'ASSET'
1516: AND ADJ.PARENT_OBJECT_ID = ASSET.ID

Line 1552: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_ASSETS_B ASSET,

1548: x_resultout := FND_API.G_RET_STS_SUCCESS;
1549: BEGIN
1550: SELECT SUM(DECODE(ADJ.VALUE, NULL, ADJ.DEFAULT_SUBSIDY_AMOUNT, ADJ.VALUE)) SUBSIDY_AMOUNT
1551: INTO l_subsidy_amount
1552: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_ASSETS_B ASSET,
1553: OKL_COST_ADJUSTMENTS_B ADJ, OKL_LEASE_QUOTES_B QUOTE
1554: WHERE ADJ.ADJUSTMENT_SOURCE_TYPE = 'SUBSIDY'
1555: AND ADJ.PARENT_OBJECT_CODE = 'ASSET'
1556: AND ADJ.PARENT_OBJECT_ID = ASSET.ID

Line 1593: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_ASSETS_B ASSET,

1589: x_resultout := FND_API.G_RET_STS_SUCCESS;
1590: BEGIN
1591: SELECT NVL(SUM(ADJ.VALUE), 0)
1592: INTO l_trade_in_amount
1593: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_ASSETS_B ASSET,
1594: OKL_COST_ADJUSTMENTS_B ADJ, OKL_LEASE_QUOTES_B QUOTE
1595: WHERE ADJ.ADJUSTMENT_SOURCE_TYPE = 'TRADEIN'
1596: AND ADJ.PARENT_OBJECT_CODE = 'ASSET'
1597: AND ADJ.PARENT_OBJECT_ID = ASSET.ID

Line 1630: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_ASSETS_B ASSET,

1626: l_trade_in_asset_number VARCHAR2(15);
1627:
1628: CURSOR cAssetNumber IS
1629: SELECT ASSET.ASSET_NUMBER
1630: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_ASSETS_B ASSET,
1631: OKL_LEASE_QUOTES_B QUOTE, OKL_COST_ADJUSTMENTS_B ADJ
1632: WHERE ADJ.ADJUSTMENT_SOURCE_TYPE = 'TRADEIN'
1633: AND ADJ.PARENT_OBJECT_CODE = 'ASSET'
1634: AND ADJ.PARENT_OBJECT_ID = ASSET.ID

Line 1693: and CFO.SOURCE_TABLE = 'OKL_ASSETS_B'

1689: where CFO.OTY_CODE = 'QUOTED_ASSET'
1690: and CFO.ID = CFL.CFO_ID
1691: and CFL.ID = LVL.CAF_ID
1692: and CFO.SOURCE_ID = l_asset_id
1693: and CFO.SOURCE_TABLE = 'OKL_ASSETS_B'
1694: AND LVL.FQY_CODE = FND.LOOKUP_CODE
1695: AND FND.LOOKUP_TYPE = 'OKL_FREQUENCY';
1696:
1697: /*UNION

Line 1705: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_ASSETS_B'

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
1704: and OKL_CASH_FLOW_OBJECTS.source_id = FEE.id
1705: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_ASSETS_B'
1706: and FEE.parent_object_id = QUOTE.id
1707: and QUOTE.parent_object_id = LAP.id
1708: and FEE.parent_object_code = 'LEASEQUOTE'
1709: and QUOTE.parent_object_code = 'LEASEAPP'

Line 1720: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_ASSETS_B'

1716: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_SERVICE'
1717: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
1718: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
1719: and OKL_CASH_FLOW_OBJECTS.source_id = SRV.id
1720: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_ASSETS_B'
1721: and SRV.parent_object_id = QUOTE.id
1722: and QUOTE.parent_object_id = LAP.id
1723: and SRV.parent_object_code = 'LEASEQUOTE'
1724: and QUOTE.parent_object_code = 'LEASEAPP'

Line 1793: and CFO.source_table = 'OKL_ASSETS_B'

1789: --Bug 7030452 :Hardcoded value '23' is removed
1790: -- and CFO.source_id = 23
1791: and CFO.source_id = l_asset_id
1792: --Bug 7030452 :End
1793: and CFO.source_table = 'OKL_ASSETS_B'
1794: AND CFL.due_arrears_yn = FND.LOOKUP_CODE
1795: AND FND.LOOKUP_TYPE = 'OKL_YES_NO';
1796:
1797: /*union

Line 1889: and CFO.SOURCE_TABLE = 'OKL_ASSETS_B';

1885: where CFO.OTY_CODE = 'QUOTED_ASSET'
1886: and CFO.ID = CFL.CFO_ID
1887: and CFL.ID = LVL.CAF_ID
1888: and CFO.SOURCE_ID = l_asset_id
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,

Line 1985: and CFO.SOURCE_TABLE = 'OKL_ASSETS_B';

1981: where CFO.OTY_CODE = 'QUOTED_ASSET'
1982: and CFO.ID = CFL.CFO_ID
1983: and CFL.ID = LVL.CAF_ID
1984: and CFO.SOURCE_ID = l_asset_id
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,

Line 2081: and CFO.SOURCE_TABLE = 'OKL_ASSETS_B';

2077: where CFO.OTY_CODE = 'QUOTED_ASSET'
2078: and CFO.ID = CFL.CFO_ID
2079: and CFL.ID = LVL.CAF_ID
2080: and CFO.SOURCE_ID = l_asset_id
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,

Line 2294: and CFO.SOURCE_TABLE = 'OKL_ASSETS_B'

2290: where CFO.OTY_CODE = 'QUOTED_ASSET'
2291: and CFO.ID = CFL.CFO_ID
2292: and CFL.ID = LVL.CAF_ID
2293: and CFO.SOURCE_ID = l_asset_id
2294: and CFO.SOURCE_TABLE = 'OKL_ASSETS_B'
2295: order by LVL.start_date; --Bug # 9116306
2296:
2297: /*union
2298: select OKL_CASH_FLOW_LEVELS.start_date end_date

Line 2344: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_ASSETS_B ASSET, OKL_CASH_FLOW_OBJECTS,

2340: and LAP.id = l_lease_app_id;*/
2341:
2342: CURSOR c_get_info IS
2343: SELECT OKL_CASH_FLOW_LEVELS.FQY_CODE FQY_CODE, QUOTE.TERM
2344: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_ASSETS_B ASSET, OKL_CASH_FLOW_OBJECTS,
2345: OKL_CASH_FLOWS, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
2346: WHERE OKL_CASH_FLOW_OBJECTS.OTY_CODE = 'QUOTED_ASSET'
2347: AND OKL_CASH_FLOW_OBJECTS.ID = OKL_CASH_FLOWS.CFO_ID
2348: AND OKL_CASH_FLOWS.ID = OKL_CASH_FLOW_LEVELS.CAF_ID

Line 2350: AND OKL_CASH_FLOW_OBJECTS.SOURCE_TABLE = 'OKL_ASSETS_B'

2346: WHERE OKL_CASH_FLOW_OBJECTS.OTY_CODE = 'QUOTED_ASSET'
2347: AND OKL_CASH_FLOW_OBJECTS.ID = OKL_CASH_FLOWS.CFO_ID
2348: AND OKL_CASH_FLOWS.ID = OKL_CASH_FLOW_LEVELS.CAF_ID
2349: AND OKL_CASH_FLOW_OBJECTS.SOURCE_ID = ASSET.ID
2350: AND OKL_CASH_FLOW_OBJECTS.SOURCE_TABLE = 'OKL_ASSETS_B'
2351: AND ASSET.PARENT_OBJECT_ID = QUOTE.ID
2352: AND QUOTE.PARENT_OBJECT_ID = LAP.ID
2353: AND ASSET.PARENT_OBJECT_CODE = 'LEASEQUOTE'
2354: AND QUOTE.PARENT_OBJECT_CODE = 'LEASEAPP'

Line 2671: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_ASSETS_B ASSET,

2667:
2668: -- added for bug 6596860 --
2669: CURSOR l_adj_sum_csr(p_lease_app_id IN NUMBER) IS
2670: SELECT NVL(SUM(VALUE),0 )
2671: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_ASSETS_B ASSET,
2672: OKL_COST_ADJUSTMENTS_B ADJ, OKL_LEASE_QUOTES_B QUOTE
2673: WHERE ADJ.PARENT_OBJECT_CODE = 'ASSET'
2674: AND ADJ.PARENT_OBJECT_ID = ASSET.ID
2675: AND ASSET.PARENT_OBJECT_ID = QUOTE.ID

Line 2691: FROM OKL_ASSETS_B AST, OKL_LEASE_QUOTES_B QUOTE, OKL_LEASE_APPLICATIONS_B LAP

2687: x_resultout := FND_API.G_RET_STS_SUCCESS;
2688:
2689: SELECT NVL(SUM(AST.OEC), 0)
2690: INTO ln_asset_cost
2691: FROM OKL_ASSETS_B AST, OKL_LEASE_QUOTES_B QUOTE, OKL_LEASE_APPLICATIONS_B LAP
2692: WHERE AST.PARENT_OBJECT_ID = QUOTE.ID
2693: AND AST.PARENT_OBJECT_CODE = 'LEASEQUOTE'
2694: AND QUOTE.PARENT_OBJECT_ID = LAP.ID
2695: AND QUOTE.PRIMARY_QUOTE = 'Y'

Line 2701: FROM OKL_ASSETS_B AST, OKL_ASSET_COMPONENTS_B AST_COMP,

2697: AND LAP.ID = l_lease_app_id;
2698:
2699: /*SELECT NVL(SUM(AST_COMP.UNIT_COST * AST_COMP.NUMBER_OF_UNITS), 0)
2700: INTO ln_addon_cost
2701: FROM OKL_ASSETS_B AST, OKL_ASSET_COMPONENTS_B AST_COMP,
2702: OKL_LEASE_QUOTES_B QUOTE, OKL_LEASE_APPLICATIONS_B LAP
2703: WHERE AST_COMP.ASSET_ID = AST.ID
2704: AND AST_COMP.PRIMARY_COMPONENT = 'NO'
2705: AND AST.PARENT_OBJECT_ID = QUOTE.ID

Line 2776: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_ASSETS_B ASSET,

2772: BEGIN
2773: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
2774: SELECT NVL(SUM(ADJ.VALUE), 0)
2775: INTO ln_down_payment_amount
2776: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_ASSETS_B ASSET,
2777: OKL_COST_ADJUSTMENTS_B ADJ, OKL_LEASE_QUOTES_B QUOTE
2778: WHERE ADJ.ADJUSTMENT_SOURCE_TYPE IN ('DOWN_PAYMENT', 'TRADEIN')
2779: AND ADJ.PARENT_OBJECT_CODE = 'ASSET'
2780: AND ADJ.PARENT_OBJECT_ID = ASSET.ID