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

TABLE: INL.INL_SHIP_LINES_INT

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


This table stores Open Interface data for Shipment Line Groups and Shipment Lines.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
INL_SHIP_LINES_INT_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSHIP_LINE_INT_ID
Columns
Name Datatype Length Mandatory Comments
SHIP_HEADER_INT_ID NUMBER
Yes Shipment Interface Identifier
SHIP_LINE_INT_ID NUMBER
Yes Shipment Line Interface Identifier
GROUP_ID NUMBER
Yes Open Interface Group Identifier
PROCESSING_STATUS_CODE VARCHAR2 (25) Yes Processing Status Code
VALIDATION_FLAG VARCHAR2 (1) Yes "Y" or "N" flag indicating whether the record should be validated
SHIP_LINE_GROUP_REFERENCE VARCHAR2 (30)
Line Group Reference
PARTY_ID NUMBER

Party Identifier
PARTY_NUMBER VARCHAR2 (30)
Party Number
PARTY_SITE_ID NUMBER

Party Site Identifier
PARTY_SITE_NUMBER VARCHAR2 (30)
Party Site Number
SOURCE_ORGANIZATION_ID NUMBER

Source Inventory Organization Identifier
SOURCE_ORGANIZATION_CODE VARCHAR2 (3)
Source Inventory Organization Code
SHIP_LINE_NUM NUMBER

Shipment Line Number
SHIP_LINE_TYPE_ID NUMBER

Shipment Line Type Identifier
SHIP_LINE_TYPE_CODE VARCHAR2 (15)
Shipment Line Type Code
SHIP_LINE_SRC_TYPE_CODE VARCHAR2 (30) Yes Source Type Code, taken from lookup INL_SHIP_LINE_SRC_TYPES
SHIP_LINE_SOURCE_ID NUMBER

Source Identifier, according to the Source Type Code
CURRENCY_CODE VARCHAR2 (15) Yes Currency Code
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
Currency Conversion Type
CURRENCY_CONVERSION_DATE DATE

Currency Conversion Date
CURRENCY_CONVERSION_RATE NUMBER

Currency Conversion Rate
INVENTORY_ITEM_ID NUMBER

Inventory Item Identifier
TXN_QTY NUMBER

Transaction Quantity
TXN_UOM_CODE VARCHAR2 (3)
Transaction Unit of Measure
TXN_UNIT_PRICE NUMBER

Transaction Unit Price
PRIMARY_QTY NUMBER

Primary Quantity
PRIMARY_UOM_CODE VARCHAR2 (3)
Primary Unit of Measure Code
PRIMARY_UNIT_PRICE NUMBER

Primary Unit Price
SECONDARY_QTY NUMBER

Secondary Quantity
SECONDARY_UOM_CODE VARCHAR2 (3)
Secondary Unit of Measure
SECONDARY_UNIT_PRICE NUMBER

Secondary Unit Price
LANDED_COST_FLAG VARCHAR2 (1) Yes "Y" or "N" flag indicating whether the amount should be considered in the landed cost
ALLOCATION_ENABLED_FLAG VARCHAR2 (1) Yes "Y" or "N" flag indicating whether the amounts of the line are associable
TRX_BUSINESS_CATEGORY VARCHAR2 (240)
Categorization of a transaction for tax purposes
INTENDED_USE VARCHAR2 (30)
Purpose for which a product may be used
PRODUCT_FISCAL_CLASS VARCHAR2 (240)
Classification of the product(s) by tax authority for tax purposes
PRODUCT_CATEGORY VARCHAR2 (240)
Used to classify products for tax purposes
PRODUCT_TYPE VARCHAR2 (240)
Product related classification for tax purposes
USER_DEF_FISCAL_CLASS VARCHAR2 (240)
User Defined Fiscal Classifiction
TAX_CLASSIFICATION_CODE VARCHAR2 (30)
Tax Classification Code
ASSESSABLE_VALUE NUMBER

EBTAX Assessable Value
SHIP_FROM_PARTY_ID NUMBER

Ship From Party Identifier
SHIP_FROM_PARTY_NUMBER VARCHAR2 (30)
Ship From Party Number
SHIP_FROM_PARTY_SITE_ID NUMBER

Ship From Party Site Identifier
SHIP_FROM_PARTY_SITE_NUMBER VARCHAR2 (30)
Ship From Party Site Number
SHIP_TO_ORGANIZATION_ID NUMBER

Ship To Organization Identifier
SHIP_TO_ORGANIZATION_CODE VARCHAR2 (3)
Ship To Organization Code
SHIP_TO_LOCATION_ID NUMBER

Ship To Location Identifier
SHIP_TO_LOCATION_CODE VARCHAR2 (60)
Ship To Location Code
BILL_FROM_PARTY_ID NUMBER

Bill From Party Identifier
BILL_FROM_PARTY_NUMBER VARCHAR2 (30)
Bill From Party Number
BILL_FROM_PARTY_SITE_ID NUMBER

Bill From Party Site Identifier
BILL_FROM_PARTY_SITE_NUMBER VARCHAR2 (30)
Bill From Party Site Number
BILL_TO_ORGANIZATION_ID NUMBER

Bill To Organization Identifier
BILL_TO_ORGANIZATION_CODE VARCHAR2 (3)
Bill To Organization Code
BILL_TO_LOCATION_ID NUMBER

Bill To Location Identifier
BILL_TO_LOCATION_CODE VARCHAR2 (60)
Bill To Location Code
POA_PARTY_ID NUMBER

Point of Order Acceptance Party Identifier
POA_PARTY_NUMBER VARCHAR2 (30)
Point of Order Acceptance Party Number
POA_PARTY_SITE_ID NUMBER

Point of Order Acceptance Party Site Identifier
POA_PARTY_SITE_NUMBER VARCHAR2 (30)
Point of Order Acceptance Party Site Number
POO_ORGANIZATION_ID NUMBER

Point of Order Origin Organization Identifier
POO_TO_ORGANIZATION_CODE VARCHAR2 (3)
Point of Order Origin Organization Code
POO_LOCATION_ID NUMBER

Point of Order Origin Location Identifier
POO_LOCATION_CODE VARCHAR2 (60)
Point of Order Origin Location Code
ORG_ID NUMBER
Yes Organization identifier
SHIP_HEADER_ID NUMBER

Shipment Identifier
SHIP_LINE_ID NUMBER

Shipment Line Identifier
INTERFACE_SOURCE_TABLE VARCHAR2 (30)
Source Table of the interface row
INTERFACE_SOURCE_LINE_ID NUMBER

Source line identifier of the interface row
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).
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).
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_APPLICATION_ID NUMBER

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

Concurrent Program who column - date when a program last updated this row).
ATTRIBUTE_CATEGORY_LG VARCHAR2 (30)
Descriptive Flexfield structure defining column
ATTRIBUTE1_LG VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE2_LG VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE3_LG VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE4_LG VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE5_LG VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE6_LG VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE7_LG VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE8_LG VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE9_LG VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE10_LG VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE11_LG VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE12_LG VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE13_LG VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE14_LG VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE15_LG VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE_CATEGORY_SL VARCHAR2 (30)
Descriptive Flexfield structure defining column
ATTRIBUTE1_SL VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE2_SL VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE3_SL VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE4_SL VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE5_SL VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE6_SL VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE7_SL VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE8_SL VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE9_SL VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE10_SL VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE11_SL VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE12_SL VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE13_SL VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE14_SL VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE15_SL VARCHAR2 (150)
Descriptive Flexfield
Query Text

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


SELECT SHIP_HEADER_INT_ID
,      SHIP_LINE_INT_ID
,      GROUP_ID
,      PROCESSING_STATUS_CODE
,      VALIDATION_FLAG
,      SHIP_LINE_GROUP_REFERENCE
,      PARTY_ID
,      PARTY_NUMBER
,      PARTY_SITE_ID
,      PARTY_SITE_NUMBER
,      SOURCE_ORGANIZATION_ID
,      SOURCE_ORGANIZATION_CODE
,      SHIP_LINE_NUM
,      SHIP_LINE_TYPE_ID
,      SHIP_LINE_TYPE_CODE
,      SHIP_LINE_SRC_TYPE_CODE
,      SHIP_LINE_SOURCE_ID
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_RATE
,      INVENTORY_ITEM_ID
,      TXN_QTY
,      TXN_UOM_CODE
,      TXN_UNIT_PRICE
,      PRIMARY_QTY
,      PRIMARY_UOM_CODE
,      PRIMARY_UNIT_PRICE
,      SECONDARY_QTY
,      SECONDARY_UOM_CODE
,      SECONDARY_UNIT_PRICE
,      LANDED_COST_FLAG
,      ALLOCATION_ENABLED_FLAG
,      TRX_BUSINESS_CATEGORY
,      INTENDED_USE
,      PRODUCT_FISCAL_CLASS
,      PRODUCT_CATEGORY
,      PRODUCT_TYPE
,      USER_DEF_FISCAL_CLASS
,      TAX_CLASSIFICATION_CODE
,      ASSESSABLE_VALUE
,      SHIP_FROM_PARTY_ID
,      SHIP_FROM_PARTY_NUMBER
,      SHIP_FROM_PARTY_SITE_ID
,      SHIP_FROM_PARTY_SITE_NUMBER
,      SHIP_TO_ORGANIZATION_ID
,      SHIP_TO_ORGANIZATION_CODE
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_LOCATION_CODE
,      BILL_FROM_PARTY_ID
,      BILL_FROM_PARTY_NUMBER
,      BILL_FROM_PARTY_SITE_ID
,      BILL_FROM_PARTY_SITE_NUMBER
,      BILL_TO_ORGANIZATION_ID
,      BILL_TO_ORGANIZATION_CODE
,      BILL_TO_LOCATION_ID
,      BILL_TO_LOCATION_CODE
,      POA_PARTY_ID
,      POA_PARTY_NUMBER
,      POA_PARTY_SITE_ID
,      POA_PARTY_SITE_NUMBER
,      POO_ORGANIZATION_ID
,      POO_TO_ORGANIZATION_CODE
,      POO_LOCATION_ID
,      POO_LOCATION_CODE
,      ORG_ID
,      SHIP_HEADER_ID
,      SHIP_LINE_ID
,      INTERFACE_SOURCE_TABLE
,      INTERFACE_SOURCE_LINE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY_LG
,      ATTRIBUTE1_LG
,      ATTRIBUTE2_LG
,      ATTRIBUTE3_LG
,      ATTRIBUTE4_LG
,      ATTRIBUTE5_LG
,      ATTRIBUTE6_LG
,      ATTRIBUTE7_LG
,      ATTRIBUTE8_LG
,      ATTRIBUTE9_LG
,      ATTRIBUTE10_LG
,      ATTRIBUTE11_LG
,      ATTRIBUTE12_LG
,      ATTRIBUTE13_LG
,      ATTRIBUTE14_LG
,      ATTRIBUTE15_LG
,      ATTRIBUTE_CATEGORY_SL
,      ATTRIBUTE1_SL
,      ATTRIBUTE2_SL
,      ATTRIBUTE3_SL
,      ATTRIBUTE4_SL
,      ATTRIBUTE5_SL
,      ATTRIBUTE6_SL
,      ATTRIBUTE7_SL
,      ATTRIBUTE8_SL
,      ATTRIBUTE9_SL
,      ATTRIBUTE10_SL
,      ATTRIBUTE11_SL
,      ATTRIBUTE12_SL
,      ATTRIBUTE13_SL
,      ATTRIBUTE14_SL
,      ATTRIBUTE15_SL
FROM INL.INL_SHIP_LINES_INT;

Dependencies

[top of page]

INL.INL_SHIP_LINES_INT does not reference any database object

INL.INL_SHIP_LINES_INT is referenced by following:

SchemaAPPS
SynonymINL_SHIP_LINES_INT