VIEW: APPS.CS_CONFIG_RG_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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