Product: | RLA - Release Management Integration Kit (Obsolete) |
---|---|
Description: | SINGLE-ORG view |
Implementation/DBA Data: | Not implemented in this database |
SELECT ASN_SEQ_NUMBER
, ITEM_METHOD_TYPE
, BILL_TO_ADDRESS_ID
, BILL_TO_SITE_USE_ID
, CREATED_BY
, CREATION_DATE
, CUSTOMER_BILL_TO_EXT
, CUSTOMER_DOCK_CODE
, CUSTOMER_EXT
, CUSTOMER_ID
, CUSTOMER_INTERMDT_SHIP_TO_EXT
, CUSTOMER_ITEM_EXT
, CUSTOMER_ITEM_ID
, CUSTOMER_JOB_NUMBER
, CUSTOMER_MODEL_SERIAL_NUMBER
, CUSTOMER_NUMBER
, CUSTOMER_PRODUCTION_LINE
, CUSTOMER_SHIP_FROM_ORG_EXT
, CUSTOMER_SHIP_TO_EXT
, CUSTOMER_UOM_EXT
, PLANNED_SHIPMENT_DATE
, DATE_REQUESTED_CURRENT
, DISPOSITION
, DOCUMENT_TYPE
, DOCUMENT_TYPE_EXT
, FORECAST_DESIGNATOR
, HEADER_ATTRIBUTE1
, HEADER_ATTRIBUTE10
, HEADER_ATTRIBUTE11
, HEADER_ATTRIBUTE12
, HEADER_ATTRIBUTE13
, HEADER_ATTRIBUTE14
, HEADER_ATTRIBUTE15
, HEADER_ATTRIBUTE2
, HEADER_ATTRIBUTE3
, HEADER_ATTRIBUTE4
, HEADER_ATTRIBUTE5
, HEADER_ATTRIBUTE6
, HEADER_ATTRIBUTE7
, HEADER_ATTRIBUTE8
, HEADER_ATTRIBUTE9
, HEADER_ATTRIBUTE_CATEGORY
, 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_ATTRIBUTE1
, LINE_ATTRIBUTE10
, LINE_ATTRIBUTE11
, LINE_ATTRIBUTE12
, LINE_ATTRIBUTE13
, LINE_ATTRIBUTE14
, LINE_ATTRIBUTE15
, LINE_ATTRIBUTE2
, LINE_ATTRIBUTE3
, LINE_ATTRIBUTE4
, LINE_ATTRIBUTE5
, LINE_ATTRIBUTE6
, LINE_ATTRIBUTE7
, LINE_ATTRIBUTE8
, LINE_ATTRIBUTE9
, LINE_ATTRIBUTE_CATEGORY
, LINE_ID
, LINE_REFERENCE
, LINK_TO_LINE_REF
, ORDER_HEADER_ID
, ORDER_NUMBER
, ORDER_TYPE_ID
, ORDER_TYPE_NAME
, ORG_ID
, ORIGINAL_SYSTEM_LINE_REFERENCE
, PARENT_LINK_LINE_REF
, PLANNING_PROD_SEQ_NUMBER
, PROCESS_STATUS
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, PO_CUM_KEY
, QUANTITY
, REQUEST_ID
, REQUIREMENT_EXT
, REQUIREMENT_TYPE
, SHIP_FROM_ORGANIZATION_ID
, SHIP_TO_ADDRESS_ID
, SHIP_TO_SITE_USE_ID
, TRANSMISSION_NAME
, TRANSACTION_SET_PURPOSE_CODE
, UOM_CODE
, ITEM_NUMBER
, PURCHASE_ORDER_NUMBER
, BUCKET_TYPE
FROM RLA_DEMAND_INTERFACE_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)