View: RLA_DEMAND_LINES_ARCHIVE

View Text

SELECT ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE_CATEGORY
, ARCHIVE_TIMESTAMP
, CREATED_BY
, CREATION_DATE
, CUSTOMER_DOCK_CODE
, CUSTOMER_ITEM_ID
, CUSTOMER_JOB_NUMBER
, CUSTOMER_MODEL_SERIAL_NUMBER
, CUSTOMER_PRODUCTION_LINE
, PLANNED_SHIPMENT_DATE
, DATE_REQUESTED_CURRENT
, DEMAND_HEADER_ID
, DEMAND_LINE_ID
, DISPOSITION
, DOCUMENT_TYPE
, FORECAST_DESIGNATOR
, INDUSTRY_ATTRIBUTE1
, INDUSTRY_ATTRIBUTE2
, INDUSTRY_ATTRIBUTE3
, INDUSTRY_ATTRIBUTE4
, INDUSTRY_ATTRIBUTE5
, INDUSTRY_ATTRIBUTE6
, INDUSTRY_ATTRIBUTE7
, INDUSTRY_ATTRIBUTE8
, INDUSTRY_ATTRIBUTE9
, INDUSTRY_ATTRIBUTE10
, INDUSTRY_ATTRIBUTE11
, INDUSTRY_ATTRIBUTE12
, INDUSTRY_ATTRIBUTE13
, INDUSTRY_ATTRIBUTE14
, INDUSTRY_ATTRIBUTE15
, INDUSTRY_CONTEXT
, INTERMEDIATE_SHIP_TO_ID
, INVENTORY_ITEM_ID
, ITEM_TYPE_CODE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LINE_REFERENCE
, LINK_TO_DEMAND_LINE_ID
, LINK_TO_LINE_REF
, ORG_ID
, ORIGINAL_SYSTEM_LINE_REFERENCE
, PARENT_LINK_LINE_REF
, PLANNING_PROD_SEQ_NUMBER
, PROCESS_STATUS
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, QUANTITY
, REQUEST_ID
, REQUIREMENT_EXT
, REQUIREMENT_TYPE
, SHIP_FROM_ORGANIZATION_ID
, SHIP_TO_ADDRESS_ID
, SHIP_TO_SITE_USE_ID
, UOM_CODE
, TRANSMISSION_NAME
, PO_CUM_KEY
, BUCKET_TYPE
, ASN_SEQ_NUMBER
, MATCH_KEY
FROM RLA_DEMAND_LINES_ARCHIVE_ALL
WHERE NVL(ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)

Columns