DBA Data[Home] [Help] [Dependency Information]

TABLE: INL.INL_SHIP_HEADERS_ALL

Object Details
Object Name: INL_SHIP_HEADERS_ALL
Object Type: TABLE
Owner: INL
FND Design Data: TableINL.INL_SHIP_HEADERS_ALL
Subobject Name:
Status: VALID


This table stores header information on Shipments.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
INL_SHIP_HEADERS_ALL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSHIP_HEADER_ID
INL_SHIP_HEADERS_ALL_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnSHIP_NUM
INL_SHIP_HEADERS_ALL_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSHIP_TYPE_ID
INL_SHIP_HEADERS_ALL_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLEGAL_ENTITY_ID
INL_SHIP_HEADERS_ALL_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLOCATION_ID
INL_SHIP_HEADERS_ALL_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSIMULATION_ID
Columns
Name Datatype Length Mandatory Comments
SHIP_HEADER_ID NUMBER
Yes Shipment Identifier
SHIP_NUM VARCHAR2 (25) Yes Shipment Number
SHIP_DATE DATE
Yes Shipment Date
SHIP_TYPE_ID NUMBER
Yes Shipment Type Identifier
SHIP_STATUS_CODE VARCHAR2 (30) Yes Shipment Status, taken from lookup INL_SHIP_STATUSES
PENDING_MATCHING_FLAG VARCHAR2 (1)
"Y" or "N" flag indicating the existence of lines matched but not absorbed by the landed cost calculation
LEGAL_ENTITY_ID NUMBER
Yes Legal Entity Identifier
ORGANIZATION_ID NUMBER
Yes Inventory Organization Identifier
LOCATION_ID NUMBER

Location Identifier
ORG_ID NUMBER
Yes Organization Identifier
TAXATION_COUNTRY VARCHAR2 (30)
Specifies the country for taxation for tax calculation purposes
DOCUMENT_SUB_TYPE VARCHAR2 (150)
EBTAX Header level field
SHIP_HEADER_INT_ID NUMBER

Shipment Interface Identifier
INTERFACE_SOURCE_CODE VARCHAR2 (25)
Source of the interface row
INTERFACE_SOURCE_TABLE VARCHAR2 (30)
Source Table of the interface row
INTERFACE_SOURCE_LINE_ID NUMBER

Source line identifier of the interface row
ADJUSTMENT_NUM NUMBER

Adjustment Number
CREATED_BY NUMBER
Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
PROGRAM_ID NUMBER

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
REQUEST_ID NUMBER

Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
RCV_ENABLED_FLAG VARCHAR2 (1)
"Y" or "N" flag indicating whether the Shipment will be received through Oracle Receiving
SIMULATION_ID NUMBER

Simulation Identifier
PENDING_UPDATE_FLAG VARCHAR2 (1)
"Y" or "N" flag indicating the existence of lines updated but not processed by the landed cost calculation
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SHIP_HEADER_ID
,      SHIP_NUM
,      SHIP_DATE
,      SHIP_TYPE_ID
,      SHIP_STATUS_CODE
,      PENDING_MATCHING_FLAG
,      LEGAL_ENTITY_ID
,      ORGANIZATION_ID
,      LOCATION_ID
,      ORG_ID
,      TAXATION_COUNTRY
,      DOCUMENT_SUB_TYPE
,      SHIP_HEADER_INT_ID
,      INTERFACE_SOURCE_CODE
,      INTERFACE_SOURCE_TABLE
,      INTERFACE_SOURCE_LINE_ID
,      ADJUSTMENT_NUM
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      RCV_ENABLED_FLAG
,      SIMULATION_ID
,      PENDING_UPDATE_FLAG
FROM INL.INL_SHIP_HEADERS_ALL;

Dependencies

[top of page]

INL.INL_SHIP_HEADERS_ALL does not reference any database object

INL.INL_SHIP_HEADERS_ALL is referenced by following:

SchemaINL
ViewINL_SHIP_HEADERS_ALL#