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_ASSET_COMPONENTS_B

Line 507: FROM MTL_SYSTEM_ITEMS_KFV ITEM, OKL_ASSET_COMPONENTS_B ASSET_COMP,

503: l_item VARCHAR2(40);
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

Line 625: FROM PO_VENDORS VENDOR, OKL_ASSET_COMPONENTS_B ASSET_COMP,

621: CURSOR cItemSupp IS
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

Line 680: FROM OKL_ASSET_COMPONENTS_B ASSET_COMP, OKL_LEASE_APPLICATIONS_B LAP,

676: l_model VARCHAR2(40);
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

Line 735: FROM OKL_ASSET_COMPONENTS_B ASSET_COMP, OKL_LEASE_APPLICATIONS_B LAP,

731: l_manufacturer VARCHAR2(360);
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

Line 789: FROM OKL_ASSET_COMPONENTS_B ASSET_COMP, OKL_LEASE_APPLICATIONS_B LAP,

785: l_year_of_manufacture NUMBER;
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

Line 842: FROM OKL_ASSET_COMPONENTS_B ASSET_COMP, OKL_LEASE_APPLICATIONS_B LAP,

838: l_no_of_units NUMBER;
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

Line 894: FROM OKL_ASSET_COMPONENTS_B ASSET_COMP, OKL_LEASE_APPLICATIONS_B LAP,

890: l_unit_cost NUMBER;
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

Line 1170: FROM MTL_SYSTEM_ITEMS_KFV ITEM, OKL_ASSET_COMPONENTS_B ASSET_COMP

1166: l_add_on_item VARCHAR2(40);
1167:
1168: CURSOR cAddOnItem IS
1169: SELECT ITEM.CONCATENATED_SEGMENTS ADD_ON_ITEM
1170: FROM MTL_SYSTEM_ITEMS_KFV ITEM, OKL_ASSET_COMPONENTS_B ASSET_COMP
1171: WHERE ITEM.INVENTORY_ITEM_ID = ASSET_COMP.INV_ITEM_ID
1172: AND ITEM.ORGANIZATION_ID = OKL_SYSTEM_PARAMS_ALL_PUB.get_system_param_value(OKL_SYSTEM_PARAMS_ALL_PUB.G_ITEM_INV_ORG_ID)
1173: AND ASSET_COMP.ASSET_ID = l_asset_id
1174: AND ASSET_COMP.PRIMARY_COMPONENT = 'NO';

Line 1218: FROM MTL_SYSTEM_ITEMS_KFV ITEM, OKL_ASSET_COMPONENTS_B ASSET_COMP

1214: l_add_on_item_description VARCHAR2(1995);
1215:
1216: CURSOR cItemDescription IS
1217: SELECT ITEM.CONCATENATED_SEGMENTS ADD_ON_ITEM
1218: FROM MTL_SYSTEM_ITEMS_KFV ITEM, OKL_ASSET_COMPONENTS_B ASSET_COMP
1219: WHERE ITEM.INVENTORY_ITEM_ID = ASSET_COMP.INV_ITEM_ID
1220: AND ITEM.ORGANIZATION_ID = OKL_SYSTEM_PARAMS_ALL_PUB.get_system_param_value(OKL_SYSTEM_PARAMS_ALL_PUB.G_ITEM_INV_ORG_ID)
1221: AND ASSET_COMP.ASSET_ID = l_asset_id
1222: AND ASSET_COMP.PRIMARY_COMPONENT = 'NO';

Line 1268: FROM PO_VENDORS VENDOR, OKL_ASSET_COMPONENTS_B ASSET_COMP

1264: l_add_on_item_supplier VARCHAR2(30);
1265:
1266: CURSOR cItemSupplier IS
1267: SELECT VENDOR.VENDOR_NAME ITEM_SUPPLIER
1268: FROM PO_VENDORS VENDOR, OKL_ASSET_COMPONENTS_B ASSET_COMP
1269: WHERE VENDOR.VENDOR_ID = ASSET_COMP.SUPPLIER_ID
1270: AND ASSET_COMP.ASSET_ID = l_asset_id
1271: AND ASSET_COMP.PRIMARY_COMPONENT = 'NO';
1272:

Line 1316: FROM OKL_ASSET_COMPONENTS_B ASSET_COMP

1312: l_add_on_item_model VARCHAR2(40);
1313:
1314: CURSOR cItemModel IS
1315: SELECT ASSET_COMP.MODEL_NUMBER MODEL_NUMBER
1316: FROM OKL_ASSET_COMPONENTS_B ASSET_COMP
1317: WHERE ASSET_COMP.ASSET_ID = l_asset_id
1318: AND ASSET_COMP.PRIMARY_COMPONENT = 'NO';
1319:
1320: ln_seq_number NUMBER :=1;

Line 1365: FROM OKL_ASSET_COMPONENTS_B ASSET_COMP

1361: l_add_on_item_manufacturer VARCHAR2(360);
1362:
1363: CURSOR cItemMfg IS
1364: SELECT ASSET_COMP.MANUFACTURER_NAME MANUFACTURER_NAME
1365: FROM OKL_ASSET_COMPONENTS_B ASSET_COMP
1366: WHERE ASSET_COMP.ASSET_ID = l_asset_id
1367: AND ASSET_COMP.PRIMARY_COMPONENT = 'NO';
1368:
1369: ln_seq_number NUMBER :=1;

Line 1413: FROM OKL_ASSET_COMPONENTS_B ASSET_COMP

1409: l_add_on_item_amount NUMBER;
1410:
1411: CURSOR cAddOnItemAmount IS
1412: SELECT ASSET_COMP.UNIT_COST UNIT_COST
1413: FROM OKL_ASSET_COMPONENTS_B ASSET_COMP
1414: WHERE ASSET_COMP.ASSET_ID = l_asset_id
1415: AND ASSET_COMP.PRIMARY_COMPONENT = 'NO';
1416:
1417: ln_seq_number NUMBER :=1;

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