DBA Data[Home] [Help]

APPS.OKL_CREDIT_DATAPOINTS_PVT dependencies on OKL_SYSTEM_PARAMS_ALL_PUB

Line 1172: AND ITEM.ORGANIZATION_ID = OKL_SYSTEM_PARAMS_ALL_PUB.get_system_param_value(OKL_SYSTEM_PARAMS_ALL_PUB.G_ITEM_INV_ORG_ID)

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';
1175:
1176: ln_seq_number NUMBER :=1;

Line 1220: AND ITEM.ORGANIZATION_ID = OKL_SYSTEM_PARAMS_ALL_PUB.get_system_param_value(OKL_SYSTEM_PARAMS_ALL_PUB.G_ITEM_INV_ORG_ID)

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';
1223:
1224: ln_seq_number NUMBER :=1;