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 734: FROM OKL_ASSET_COMPONENTS_B ASSET_COMP, OKL_LEASE_APPLICATIONS_B LAP,

730: l_manufacturer VARCHAR2(30);
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

Line 788: FROM OKL_ASSET_COMPONENTS_B ASSET_COMP, OKL_LEASE_APPLICATIONS_B LAP,

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

Line 841: FROM OKL_ASSET_COMPONENTS_B ASSET_COMP, OKL_LEASE_APPLICATIONS_B LAP,

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

Line 893: FROM OKL_ASSET_COMPONENTS_B ASSET_COMP, OKL_LEASE_APPLICATIONS_B LAP,

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

Line 1169: FROM MTL_SYSTEM_ITEMS_KFV ITEM, OKL_ASSET_COMPONENTS_B ASSET_COMP

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

Line 1217: FROM MTL_SYSTEM_ITEMS_KFV ITEM, OKL_ASSET_COMPONENTS_B ASSET_COMP

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

Line 1267: FROM PO_VENDORS VENDOR, OKL_ASSET_COMPONENTS_B ASSET_COMP

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

Line 1315: FROM OKL_ASSET_COMPONENTS_B ASSET_COMP

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

Line 1363: FROM OKL_ASSET_COMPONENTS_B ASSET_COMP

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

Line 1411: FROM OKL_ASSET_COMPONENTS_B ASSET_COMP

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

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