VIEW: APPS.CS_CP_REVISIONS_MAINT_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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