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