Product: | CS - Service |
---|---|
Description: | Revision Details of a Product in InstalledBase |
Implementation/DBA Data: | APPS.CS_CP_REVISIONS_MAINT_V |
SELECT CCR.ROWID ROW_ID
, CCR.CP_REVISION_ID
, CCR.OBJECT_VERSION_NUMBER
, CCR.CUSTOMER_PRODUCT_ID
, CCR.INVENTORY_ITEM_ID
, CCR.SERIAL_NUMBER
, CCR.REVISION
, CCR.SHIPPED_FLAG
, CCR.DELIVERED_FLAG
, CCR.ORDER_LINE_ID
, CCR.LINE_SERVICE_DETAIL_ID
, CCR.SHIPPED_DATE
, CCR.LOT_NUMBER
, CCR.START_DATE_ACTIVE
, CCR.END_DATE_ACTIVE
, CCR.LAST_UPDATE_DATE
, CCR.LAST_UPDATED_BY
, CCR.CREATION_DATE
, CCR.CREATED_BY
, CCR.LAST_UPDATE_LOGIN
, CCR.ATTRIBUTE1
, CCR.ATTRIBUTE2
, CCR.ATTRIBUTE3
, CCR.ATTRIBUTE4
, CCR.ATTRIBUTE5
, CCR.ATTRIBUTE6
, CCR.ATTRIBUTE7
, CCR.ATTRIBUTE8
, CCR.ATTRIBUTE9
, CCR.ATTRIBUTE10
, CCR.ATTRIBUTE11
, CCR.ATTRIBUTE12
, CCR.ATTRIBUTE13
, CCR.ATTRIBUTE14
, CCR.ATTRIBUTE15
, CCR.CONTEXT
, SI.BOM_ITEM_TYPE
, OOH.ORDERED_DATE
, OOH.ORDER_NUMBER
, OOL.LINE_NUMBER
, KFV.CONCATENATED_SEGMENTS PRODUCT
, CCR.NET_AMOUNT
, CCR.CURRENCY_CODE
, CS_STD.GET_ITEM_REV_DESC((CS_STD.GET_ITEM_VALDN_ORGZN_ID)
, CCR.INVENTORY_ITEM_ID
, CCR.REVISION) REVISION_DESCRIPTION
FROM MTL_SYSTEM_ITEMS SI
, CS_CP_REVISIONS CCR
, OE_ORDER_HEADERS_ALL OOH
, OE_ORDER_LINES_ALL OOL
, MTL_SYSTEM_ITEMS_KFV KFV
, CS_CUSTOMER_PRODUCTS_ALL CP
WHERE CP.CUSTOMER_PRODUCT_ID = CCR.CUSTOMER_PRODUCT_ID AND OOL.HEADER_ID = OOH.HEADER_ID (+) AND CP.ORIGINAL_ORDER_LINE_ID = OOL.LINE_ID (+) AND CP.INVENTORY_ITEM_ID = SI.INVENTORY_ITEM_ID AND SI.ORGANIZATION_ID = TO_NUMBER( CS_STD.GET_ITEM_VALDN_ORGZN_ID) AND CP.INVENTORY_ITEM_ID = KFV.INVENTORY_ITEM_ID AND KFV.ORGANIZATION_ID = CS_STD.GET_ITEM_VALDN_ORGZN_ID