APPS.OKL_CREDIT_DATAPOINTS_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

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 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';