[Home] [Help] [Dependency Information]
Object Name: | SO_LINE_ATTRIBUTES_INTERFACE# |
---|---|
Object Type: | VIEW |
Owner: | OE |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORDER_SOURCE_ID | NUMBER | Yes | ||
ORIGINAL_SYSTEM_REFERENCE | VARCHAR2 | (50) | Yes | |
ORIGINAL_SYSTEM_LINE_REFERENCE | VARCHAR2 | (50) | Yes | |
OPERATION_CODE | VARCHAR2 | (30) | ||
ERROR_FLAG | VARCHAR2 | (1) | ||
INTERFACE_STATUS | VARCHAR2 | (1000) | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_UPDATE_DATE | DATE | |||
REQUEST_ID | NUMBER | |||
INDUSTRY_CONTEXT | VARCHAR2 | (30) | ||
INDUSTRY_ATTRIBUTE1 | VARCHAR2 | (150) | ||
INDUSTRY_ATTRIBUTE2 | VARCHAR2 | (150) | ||
INDUSTRY_ATTRIBUTE3 | VARCHAR2 | (150) | ||
INDUSTRY_ATTRIBUTE4 | VARCHAR2 | (150) | ||
INDUSTRY_ATTRIBUTE5 | VARCHAR2 | (150) | ||
INDUSTRY_ATTRIBUTE6 | VARCHAR2 | (150) | ||
INDUSTRY_ATTRIBUTE7 | VARCHAR2 | (150) | ||
INDUSTRY_ATTRIBUTE8 | VARCHAR2 | (150) | ||
INDUSTRY_ATTRIBUTE9 | VARCHAR2 | (150) | ||
INDUSTRY_ATTRIBUTE10 | VARCHAR2 | (150) | ||
INDUSTRY_ATTRIBUTE11 | VARCHAR2 | (150) | ||
INDUSTRY_ATTRIBUTE12 | VARCHAR2 | (150) | ||
INDUSTRY_ATTRIBUTE13 | VARCHAR2 | (150) | ||
INDUSTRY_ATTRIBUTE14 | VARCHAR2 | (150) | ||
INDUSTRY_ATTRIBUTE15 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) |
Cut, paste (and edit) the following text to query this object:
SELECT ORDER_SOURCE_ID
, ORIGINAL_SYSTEM_REFERENCE
, ORIGINAL_SYSTEM_LINE_REFERENCE
, OPERATION_CODE
, ERROR_FLAG
, INTERFACE_STATUS
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, INDUSTRY_CONTEXT
, 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
, GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
FROM OE.SO_LINE_ATTRIBUTES_INTERFACE#;
|
|
|