VIEW: APPS.CS_REVISION_SERIAL_NUM_RG_V

Source

View Text - Preformatted

SELECT REV.REVISION , CS_STD.GET_ITEM_REV_DESC(CSCP.MANUFACTURING_ORG_ID, REV.INVENTORY_ITEM_ID,REV.REVISION,'FALSE') DESCRIPTION , REV.SERIAL_NUMBER SERIAL_NUMBER , REV.LOT_NUMBER LOT_NUMBER , REV.CP_REVISION_ID , REV.ORDER_NUMBER ORDER_NUMBER , REV.CUSTOMER_PRODUCT_ID FROM CS_SYSTEM_PARAMETERS CSCP, CS_CP_REVISIONS REV WHERE TRUNC(SYSDATE) BETWEEN TRUNC(NVL(REV.START_DATE_ACTIVE,SYSDATE)) AND TRUNC(NVL(REV.END_DATE_ACTIVE,SYSDATE))

View Text - HTML Formatted

SELECT REV.REVISION
, CS_STD.GET_ITEM_REV_DESC(CSCP.MANUFACTURING_ORG_ID
, REV.INVENTORY_ITEM_ID
, REV.REVISION
, 'FALSE') DESCRIPTION
, REV.SERIAL_NUMBER SERIAL_NUMBER
, REV.LOT_NUMBER LOT_NUMBER
, REV.CP_REVISION_ID
, REV.ORDER_NUMBER ORDER_NUMBER
, REV.CUSTOMER_PRODUCT_ID
FROM CS_SYSTEM_PARAMETERS CSCP
, CS_CP_REVISIONS REV
WHERE TRUNC(SYSDATE) BETWEEN TRUNC(NVL(REV.START_DATE_ACTIVE
, SYSDATE))
AND TRUNC(NVL(REV.END_DATE_ACTIVE
, SYSDATE))