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 735: OKL_ASSETS_B ASSET, OKL_LEASE_QUOTES_B QUOTE

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

Line 789: OKL_ASSETS_B ASSET, OKL_LEASE_QUOTES_B QUOTE

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

Line 842: OKL_ASSETS_B ASSET, OKL_LEASE_QUOTES_B QUOTE

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

Line 894: OKL_ASSETS_B ASSET, OKL_LEASE_QUOTES_B QUOTE

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

Line 948: OKL_ASSETS_B ASSET, OKL_LEASE_QUOTES_B QUOTE

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

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

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

Line 1510: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_ASSETS_B ASSET,

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

Line 1550: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_ASSETS_B ASSET,

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

Line 1591: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_ASSETS_B ASSET,

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

Line 1628: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_ASSETS_B ASSET,

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

Line 1691: and CFO.SOURCE_TABLE = 'OKL_ASSETS_B'

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

Line 1703: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_ASSETS_B'

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

Line 1718: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_ASSETS_B'

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

Line 1791: and CFO.source_table = 'OKL_ASSETS_B'

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

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

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

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

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

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

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

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

2288: where CFO.OTY_CODE = 'QUOTED_ASSET'
2289: and CFO.ID = CFL.CFO_ID
2290: and CFL.ID = LVL.CAF_ID
2291: and CFO.SOURCE_ID = l_asset_id
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,

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

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

Line 2347: AND OKL_CASH_FLOW_OBJECTS.SOURCE_TABLE = 'OKL_ASSETS_B'

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

Line 2668: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_ASSETS_B ASSET,

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

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

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

Line 2698: FROM OKL_ASSETS_B AST, OKL_ASSET_COMPONENTS_B AST_COMP,

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

Line 2773: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_ASSETS_B ASSET,

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