DBA Data[Home] [Help]

APPS.OKL_CREDIT_DATAPOINTS_PVT dependencies on OKL_SYSTEM_PARAMS_ALL_PUB

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

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

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

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