View: CS_CUST_PROD_MAINT_V

View Text

SELECT CP.ROWID ROW_ID
, HZA.ACCOUNT_NUMBER
, HZP.PARTY_NAME
, CP.CUSTOMER_PRODUCT_ID
, CP.LAST_UPDATE_DATE
, CP.LAST_UPDATED_BY
, CP.CREATION_DATE
, CP.CREATED_BY
, CP.LAST_UPDATE_LOGIN
, CP.CUSTOMER_ID
, CP.INVENTORY_ITEM_ID
, CP.CREATED_MANUALLY_FLAG
, CP.MOST_RECENT_FLAG
, CP.CURRENT_CP_REVISION_ID
, CP.CURRENT_SERIAL_NUMBER
, CP.TYPE_CODE
, CP.SYSTEM_ID
, CP.INSTALLATION_DATE
, CP.ORIGINAL_ORDER_LINE_ID
, OOH.ORDERED_DATE
, OOH.ORDER_NUMBER
, OOL.LINE_NUMBER
, OOL.LINK_TO_LINE_ID
, CP.ORIGINAL_LINE_SERV_DETAIL_ID
, OOL.UNIT_SELLING_PRICE
, OOH.PRICE_LIST_ID
, CP.SHIP_TO_SITE_USE_ID
, CP.BILL_TO_SITE_USE_ID
, CP.INSTALL_SITE_USE_ID
, CP.QUANTITY
, CP.SHIPPED_FLAG
, CP.DELIVERED_FLAG
, CP.UNIT_OF_MEASURE_CODE
, CP.PARENT_CP_ID
, CP.START_DATE_ACTIVE
, CP.END_DATE_ACTIVE
, CP.ATTRIBUTE1
, CP.ATTRIBUTE2
, CP.ATTRIBUTE3
, CP.ATTRIBUTE4
, CP.ATTRIBUTE5
, CP.ATTRIBUTE6
, CP.ATTRIBUTE7
, CP.ATTRIBUTE8
, CP.ATTRIBUTE9
, CP.ATTRIBUTE10
, CP.CONTEXT
, CP.CUSTOMER_PRODUCT_STATUS_ID
, CP.ATTRIBUTE11
, CP.ATTRIBUTE12
, CP.ATTRIBUTE13
, CP.ATTRIBUTE14
, CP.ATTRIBUTE15
, CP.SHIPPED_DATE
, CP.ORG_ID
, CP.REFERENCE_NUMBER
, OOH.CUST_PO_NUMBER
, CP.LOT_NUMBER CP_LOT_NUMBER
, CP.SPLIT_FLAG
, CPS.NAME CP_STATUS
, CPS.CANCELLED_FLAG
, CPS.TERMINATED_FLAG
, CPS.STATUS_CHANGE_ALLOWED_FLAG
, CPS.INCIDENT_ALLOWED_FLAG
, CPS.SERVICE_ORDER_ALLOWED_FLAG
, S.NAME SYSTEM
, L.MEANING CP_TYPE
, A1.NAME PRODUCT_AGREEMENT
, CP.PRODUCT_AGREEMENT_ID
, R.REVISION
, SI.SERIAL_NUMBER_CONTROL_CODE
, SI.DESCRIPTION PRODUCT_DESCRIPTION
, SI.BOM_ITEM_TYPE
, CP.RETURN_BY_DATE
, CP.ACTUAL_RETURNED_DATE
, CP.CONFIG_ENABLED_FLAG
, CP.CONFIG_START_DATE
, CP.CONFIG_END_DATE
, CP.CONFIG_ROOT_ID
, CP.CONFIG_PARENT_ID
, CP.CONFIG_TYPE
, L3.MEANING
, CP.RMA_LINE_ID
, CP.PROJECT_ID
, CP.TASK_ID
, CP.PLATFORM_VERSION_ID
, KFV.CONCATENATED_SEGMENTS
, CSXCUMPI_PUB.GET_PART_INFORMATION(CP.CONFIG_PARENT_ID) CONFIG_PARENT_INFO
, CSXCUMPI_PUB.GET_PART_INFORMATION(CP.CONFIG_ROOT_ID) CONFIG_ROOT_INFO
, CSXCUMPI_PUB.GET_CHILDREN_FLAG(CP.CUSTOMER_PRODUCT_ID) CONFIG_CHILDREN_FLAG
, CP.MERCHANT_VIEW_FLAG
, CP.CUSTOMER_VIEW_FLAG
FROM CS_CUSTOMER_PRODUCTS_ALL CP
, CS_LOOKUPS L
, CS_LOOKUPS L3
, CS_CUSTOMER_PRODUCT_STATUSES CPS
, CS_SYSTEMS S
, MTL_SYSTEM_ITEMS SI
, MTL_SYSTEM_ITEMS_KFV KFV
, CS_CP_REVISIONS R
, OE_AGREEMENTS A1
, ASO_I_OE_ORDER_HEADERS_V OOH
, ASO_I_OE_ORDER_LINES_V OOL
, HZ_CUST_ACCOUNTS HZA
, HZ_PARTIES HZP
WHERE CP.SYSTEM_ID = S.SYSTEM_ID(+)
AND CP.TYPE_CODE = L.LOOKUP_CODE(+)
AND L.LOOKUP_TYPE(+) = 'CUSTOMER_PRODUCT_TYPE'
AND CP.PRODUCT_AGREEMENT_ID = A1.AGREEMENT_ID(+)
AND CP.CUSTOMER_PRODUCT_ID = R.CUSTOMER_PRODUCT_ID
AND CP.CURRENT_CP_REVISION_ID = R.CP_REVISION_ID
AND CP.CUSTOMER_PRODUCT_STATUS_ID = CPS.CUSTOMER_PRODUCT_STATUS_ID
AND CP.INVENTORY_ITEM_ID = SI.INVENTORY_ITEM_ID
AND SI.ORGANIZATION_ID = ( SELECT CS_STD.GET_ITEM_VALDN_ORGZN_ID
FROM DUAL )
AND CP.INVENTORY_ITEM_ID = KFV.INVENTORY_ITEM_ID
AND KFV.ORGANIZATION_ID = ( SELECT CS_STD.GET_ITEM_VALDN_ORGZN_ID
FROM DUAL )
AND CP.CONFIG_TYPE = L3.LOOKUP_CODE(+)
AND L3.LOOKUP_TYPE(+) = 'CS_IB_CONFIG_MANAGEMENT_TYPE'
AND CP.ORIGINAL_ORDER_LINE_ID = OOL.LINE_ID(+)
AND OOL.HEADER_ID = OOH.HEADER_ID(+)
AND HZA.CUST_ACCOUNT_ID = CP.CUSTOMER_ID
AND HZA.PARTY_ID = HZP.PARTY_ID

Columns