View: CS_CONFIG_RG_V

Product:	CS - Service
Description:	Configuration Information for product and its subcomponents
Implementation/DBA Data:	APPS.CS_CONFIG_RG_V

View Text

SELECT CP1.CUSTOMER_PRODUCT_ID PARENT_CP_ID
, CP1.REFERENCE_NUMBER PARENT_REFERENCE_NUMBER
, KFV1.CONCATENATED_SEGMENTS PARENT_PRODUCT
, KFV1.DESCRIPTION PARENT_PRODUCT_DESCRIPTION
, CP1.LOT_NUMBER PARENT_LOT_NUMBER
, CP1.CURRENT_SERIAL_NUMBER PARENT_SERIAL_NUMBER
, CP2.REFERENCE_NUMBER TOP_REFERENCE_NUMBER
, KFV2.CONCATENATED_SEGMENTS TOP_PRODUCT
, KFV2.DESCRIPTION TOP_PRODUCT_DESCRIPTION
, CP2.LOT_NUMBER TOP_LOT_NUMBER
, CP2.CURRENT_SERIAL_NUMBER TOP_SERIAL_NUMBER
FROM MTL_SYSTEM_ITEMS_KFV KFV1
, MTL_SYSTEM_ITEMS_KFV KFV2
, CS_CUSTOMER_PRODUCTS_ALL CP1
, CS_CUSTOMER_PRODUCTS_ALL CP2
WHERE CP1. INVENTORY_ITEM_ID = KFV1.INVENTORY_ITEM_ID
AND KFV1.ORGANIZATION_ID = CS_STD.GET_ITEM_VALDN_ORGZN_ID
AND CP2. INVENTORY_ITEM_ID = KFV2.INVENTORY_ITEM_ID
AND KFV2.ORGANIZATION_ID = CS_STD.GET_ITEM_VALDN_ORGZN_ID
AND CP2.CUSTOMER_PRODUCT_ID = CP1.CONFIG_ROOT_ID

Columns