Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - INL Tables and Views

TABLE - INL.INL_ALLOCATIONS
TABLE - INL.INL_ALWD_LINE_TYPES
TABLE - INL.INL_ALWD_PARTY_TYPES
TABLE - INL.INL_ALWD_PARTY_USAGES
TABLE - INL.INL_ALWD_SOURCE_TYPES
TABLE - INL.INL_ASSOCIATIONS
TABLE - INL.INL_ATTRIBUTES_B
TABLE - INL.INL_ATTRIBUTES_TL
TABLE - INL.INL_CHARGE_LINES
TABLE - INL.INL_CONDITIONS
TABLE - INL.INL_ENTITIES_B
TABLE - INL.INL_ENTITIES_TL
TABLE - INL.INL_INTERFACE_ERRORS
TABLE - INL.INL_MATCHES
TABLE - INL.INL_MATCHES_INT
TABLE - INL.INL_MATCH_AMOUNTS
TABLE - INL.INL_MATCH_AMOUNTS_INT
TABLE - INL.INL_PARAMETERS
TABLE - INL.INL_RULES_B
TABLE - INL.INL_RULES_TL
TABLE - INL.INL_SHIP_HEADERS_ALL
TABLE - INL.INL_SHIP_HEADERS_INT
TABLE - INL.INL_SHIP_HOLDS
TABLE - INL.INL_SHIP_LINES_ALL
TABLE - INL.INL_SHIP_LINES_INT
TABLE - INL.INL_SHIP_LINE_GROUPS
TABLE - INL.INL_SHIP_LINE_TYPES_B
TABLE - INL.INL_SHIP_LINE_TYPES_TL
TABLE - INL.INL_SHIP_TYPES_B
TABLE - INL.INL_SHIP_TYPES_TL
TABLE - INL.INL_SIMULATIONS
TABLE - INL.INL_TAX_LINES
VIEW - APPS.INL_ADJ_ASSOCIATIONS_V
VIEW - APPS.INL_ADJ_CHARGE_LINES_V
VIEW - APPS.INL_ADJ_SHIP_LINES_V
VIEW - APPS.INL_ADJ_TAX_LINES_V
VIEW - APPS.INL_ALLOCATIONS_V
VIEW - APPS.INL_ALLOCATION_BASIS_VL
VIEW - APPS.INL_ALLOCATION_FLOW_V
VIEW - APPS.INL_ALLOCATION_SUMMARY_V
VIEW - APPS.INL_ATTRIBUTES_VL
VIEW - APPS.INL_CHARGE_LINE_TYPES_VL
VIEW - APPS.INL_CHARGE_OVERALL_V
VIEW - APPS.INL_CORR_MATCHES_V
VIEW - APPS.INL_CORR_MATCH_AMOUNTS_V
VIEW - APPS.INL_DET_LANDED_COSTS_V
VIEW - APPS.INL_EBTAX_LINES_V
VIEW - APPS.INL_ENTER_RECEIPTS_PO_V
VIEW - APPS.INL_ENTER_RECEIPTS_V
VIEW - APPS.INL_ENTITIES_VL
VIEW - APPS.INL_IR_SOURCE_LINES_V
VIEW - APPS.INL_PO_CHARGES_V
VIEW - APPS.INL_PO_CHARGE_ALLOCATIONS_V
VIEW - APPS.INL_PO_SOURCE_LINES_V
VIEW - APPS.INL_RMA_SOURCE_LINES_V
VIEW - APPS.INL_RULES_VL
VIEW - APPS.INL_SHIPLN_LANDED_COSTS_V
VIEW - APPS.INL_SHIP_IR_OVERALL_V
VIEW - APPS.INL_SHIP_LANDED_COSTS_V
VIEW - APPS.INL_SHIP_LINE_TYPES_VL
VIEW - APPS.INL_SHIP_OVERALL_V
VIEW - APPS.INL_SHIP_PO_OVERALL_V
VIEW - APPS.INL_SHIP_RMA_OVERALL_V
VIEW - APPS.INL_SHIP_TYPES_VL

Table: INL_ALLOCATIONS

Description: This table stores all amounts of a Shipment, prorated into its Shipment Lines.
Comments

This table stores all amounts of a Shipment, prorated into its Shipment Lines.

Indexes
Index Type Tablespace Column
INL_ALLOCATIONS_U1 UNIQUE APPS_TS_TX_IDX ALLOCATION_ID
INL_ALLOCATIONS_N1 NONUNIQUE APPS_TS_TX_IDX SHIP_HEADER_ID
ADJUSTMENT_NUM
SHIP_LINE_ID
INL_ALLOCATIONS_N2 NONUNIQUE APPS_TS_TX_IDX FROM_PARENT_TABLE_ID
FROM_PARENT_TABLE_NAME
INL_ALLOCATIONS_N3 NONUNIQUE APPS_TS_TX_IDX TO_PARENT_TABLE_ID
TO_PARENT_TABLE_NAME
INL_ALLOCATIONS_N4 NONUNIQUE APPS_TS_TX_IDX ASSOCIATION_ID
INL_ALLOCATIONS_N5 NONUNIQUE APPS_TS_TX_IDX SHIP_LINE_ID
Columns
Name Datatype Length Mandatory Comments
ALLOCATION_ID NUMBER
Y Allocation Identifier
SHIP_HEADER_ID NUMBER
Y Shipment Identifier
ASSOCIATION_ID NUMBER

Association Identifier
FROM_PARENT_TABLE_NAME VARCHAR2 (30) Y Name of the table the amount comes from: INL_SHIP_LINES, INL_CHARGE_LINES, INL_TAX_LINES
FROM_PARENT_TABLE_ID NUMBER
Y Identifier of the table line the amount comes from: SHIP_LINE_ID, CHARGE_LINE_ID, TAX_LINE_ID
TO_PARENT_TABLE_NAME VARCHAR2 (30) Y Name of the table the amount goes to: INL_SHIP_HEADERS, INL_SHIP_LINE_GROUPS, INL_SHIP_LINES
TO_PARENT_TABLE_ID NUMBER
Y Identifier of the table line the amount goes to: SHIP_HEADER_ID, SHIP_LINE_GROUP_ID, SHIP_LINE_ID
SHIP_LINE_ID NUMBER

Shipment Line Identifier
PARENT_ALLOCATION_ID NUMBER

Parent Allocation Identifier
ADJUSTMENT_NUM NUMBER
Y Adjustment Number
ALLOCATION_AMT NUMBER
Y Allocation Amount
LANDED_COST_FLAG VARCHAR2 (1) Y "Y" or "N" flag indicating whether the amount should be considered in the landed cost
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y 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).

[top of page]

INL.INL_ALLOCATIONS does not reference any database object

INL.INL_ALLOCATIONS is referenced by following:

INL
VIEW - INL_ALLOCATIONS#

[top of page]

Table: INL_ALWD_LINE_TYPES

Description: This table stores Shipment Line Types for Shipment Types.
Comments

This table stores Shipment Line Types for Shipment Types.

Indexes
Index Type Tablespace Column
INL_ALWD_LINE_TYPES_U1 UNIQUE APPS_TS_TX_IDX ALWD_LINE_TYPE_ID
INL_ALWD_LINE_TYPES_N1 NONUNIQUE APPS_TS_TX_IDX SHIP_LINE_TYPE_ID
INL_ALWD_LINE_TYPES_N2 NONUNIQUE APPS_TS_TX_IDX PARENT_TABLE_ID
PARENT_TABLE_NAME
Columns
Name Datatype Length Mandatory Comments
ALWD_LINE_TYPE_ID NUMBER
Y Allowed Line Type Identifier
PARENT_TABLE_NAME VARCHAR2 (30) Y Name of the table the Line Type refers to: INL_SHIP_TYPES.
PARENT_TABLE_ID NUMBER
Y Identifier of the table line the Line Type refers to: SHIP_TYPE_ID.
SHIP_LINE_TYPE_ID NUMBER
Y Shipment Line Type Identifier
DFLT_SHIP_LINE_TYPE_FLAG VARCHAR2 (1) Y "Y" or "N" flag indicating whether the Shipment Line Type is default
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID)
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID)
LAST_UPDATE_DATE DATE
Y 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)

[top of page]

INL.INL_ALWD_LINE_TYPES does not reference any database object

INL.INL_ALWD_LINE_TYPES is referenced by following:

INL
VIEW - INL_ALWD_LINE_TYPES#

[top of page]

Table: INL_ALWD_PARTY_TYPES

Description: This table stores Party Types that are allowed for a Shipment Type.
Comments

This table stores Party Types that are allowed for a Shipment Type.

Indexes
Index Type Tablespace Column
INL_ALWD_PARTY_TYPES_U1 UNIQUE APPS_TS_TX_IDX ALWD_PARTY_TYPE_ID
INL_ALWD_PARTY_TYPES_U2 UNIQUE APPS_TS_TX_IDX PARENT_TABLE_NAME
PARENT_TABLE_ID
PARTY_TYPE_CODE
Columns
Name Datatype Length Mandatory Comments
ALWD_PARTY_TYPE_ID NUMBER
Y Allowed Party Type Identifier
PARENT_TABLE_NAME VARCHAR2 (30) Y Name of the table the Party Type refers to: INL_SHIP_TYPES
PARENT_TABLE_ID NUMBER
Y Identifier of the table line the Party Type refers to: SHIP_TYPE_ID
PARTY_TYPE_CODE VARCHAR2 (30) Y Party Site Code
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID)
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID)
LAST_UPDATE_DATE DATE
Y 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)

[top of page]

INL.INL_ALWD_PARTY_TYPES does not reference any database object

INL.INL_ALWD_PARTY_TYPES is referenced by following:

INL
VIEW - INL_ALWD_PARTY_TYPES#

[top of page]

Table: INL_ALWD_PARTY_USAGES

Description: This table stores Party Usages that are allowed for a Shipment Type.
Comments

This table stores Party Usages that are allowed for a Shipment Type.

Indexes
Index Type Tablespace Column
INL_ALWD_PARTY_USAGES_U1 UNIQUE APPS_TS_TX_IDX ALWD_PARTY_USAGE_ID
INL_ALWD_PARTY_USAGES_U2 UNIQUE APPS_TS_TX_IDX PARENT_TABLE_NAME
PARENT_TABLE_ID
PARTY_USAGE_CODE
Columns
Name Datatype Length Mandatory Comments
ALWD_PARTY_USAGE_ID NUMBER
Y Allowed Party Usage Identifier
PARENT_TABLE_NAME VARCHAR2 (30) Y Name of the table the Party Usage refers to: INL_SHIP_TYPES
PARENT_TABLE_ID NUMBER
Y Identifier of the table line the Party Usage refers to: SHIP_TYPE_ID
PARTY_USAGE_CODE VARCHAR2 (30) Y Third Party Type Code
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID)
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID)
LAST_UPDATE_DATE DATE
Y 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)

[top of page]

INL.INL_ALWD_PARTY_USAGES does not reference any database object

INL.INL_ALWD_PARTY_USAGES is referenced by following:

INL
VIEW - INL_ALWD_PARTY_USAGES#

[top of page]

Table: INL_ALWD_SOURCE_TYPES

Description: This table stores Source Types that are allowed for a Shipment Type.
Comments

This table stores Source Types that are allowed for a Shipment Type.

Indexes
Index Type Tablespace Column
INL_ALWD_SOURCE_TYPES_U1 UNIQUE APPS_TS_TX_IDX ALWD_SOURCE_TYPE_ID
INL_ALWD_SOURCE_TYPES_U2 UNIQUE APPS_TS_TX_IDX SHIP_TYPE_ID
SHIP_LINE_SRC_TYPE_CODE
Columns
Name Datatype Length Mandatory Comments
ALWD_SOURCE_TYPE_ID NUMBER
Y Allowed Source Type Identifier
SHIP_TYPE_ID NUMBER
Y Shipment Type Identifier
SHIP_LINE_SRC_TYPE_CODE VARCHAR2 (30) Y Source Type Code, taken from lookup INL_SHIP_LINE_SRC_TYPES
DFLT_SOURCE_TYPE_FLAG VARCHAR2 (1)
"Y" or "N" flag indicating whether the Source Type Code is default
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID)
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID)
LAST_UPDATE_DATE DATE
Y 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)

[top of page]

INL.INL_ALWD_SOURCE_TYPES does not reference any database object

INL.INL_ALWD_SOURCE_TYPES is referenced by following:

INL
VIEW - INL_ALWD_SOURCE_TYPES#

[top of page]

Table: INL_ASSOCIATIONS

Description: This table stores associations between landed cost components of the same or different Shipments.
Comments

This table stores associations between landed cost components of the same or different Shipments.

Indexes
Index Type Tablespace Column
INL_ASSOCIATIONS_U1 UNIQUE APPS_TS_TX_IDX ASSOCIATION_ID
INL_ASSOCIATIONS_N1 NONUNIQUE APPS_TS_TX_IDX SHIP_HEADER_ID
FROM_PARENT_TABLE_NAME
TO_PARENT_TABLE_NAME
INL_ASSOCIATIONS_N2 NONUNIQUE APPS_TS_TX_IDX FROM_PARENT_TABLE_ID
FROM_PARENT_TABLE_NAME
INL_ASSOCIATIONS_N3 NONUNIQUE APPS_TS_TX_IDX TO_PARENT_TABLE_ID
TO_PARENT_TABLE_NAME
Columns
Name Datatype Length Mandatory Comments
ASSOCIATION_ID NUMBER
Y Association Identifier
SHIP_HEADER_ID NUMBER
Y Shipment Identifier
FROM_PARENT_TABLE_NAME VARCHAR2 (30) Y Name of the table the amount comes from: INL_SHIP_LINES, INL_CHARGE_LINES, INL_TAX_LINES
FROM_PARENT_TABLE_ID NUMBER
Y Identifier of the table line the amount comes from: SHIP_LINE_ID, CHARGE_LINE_ID, TAX_LINE_ID
TO_PARENT_TABLE_NAME VARCHAR2 (30) Y Name of the table the amount goes to: INL_SHIP_HEADERS, INL_SHIP_LINE_GROUPS, INL_SHIP_LINES
TO_PARENT_TABLE_ID NUMBER
Y Identifier of the table line the amount goes to: SHIP_HEADER_ID, SHIP_LINE_GROUP_ID, SHIP_LINE_ID
ALLOCATION_BASIS VARCHAR2 (30) Y Criteria through which an associated amount will be distributed into two or more components of a shipment
ALLOCATION_UOM_CODE VARCHAR2 (3)
Unit of measure through which the associated amount will be distributed into two or more components of a shipment
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID)
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID)
LAST_UPDATE_DATE DATE
Y 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)
ADJUSTMENT_TYPE_FLAG VARCHAR2 (1)
"A" or "R" flag to indicate whether the association will be added ("A") or removed ("R"), when the completed shipment is submitted

[top of page]

INL.INL_ASSOCIATIONS does not reference any database object

INL.INL_ASSOCIATIONS is referenced by following:

INL
VIEW - INL_ASSOCIATIONS#

[top of page]

Table: INL_ATTRIBUTES_B

Description: This table stores common characteristics of Attributes.
Comments
Indexes
Index Type Tablespace Column
INL_ATTRIBUTES_B_U1 UNIQUE APPS_TS_TX_IDX ATTRIBUTE_CODE
ENTITY_CODE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
ATTRIBUTE_CODE VARCHAR2 (30) Y Attribute Code
ENTITY_CODE VARCHAR2 (30) Y Entity Code
DATATYPE_CODE VARCHAR2 (1) Y DataType Code
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y 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).
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

INL.INL_ATTRIBUTES_B does not reference any database object

INL.INL_ATTRIBUTES_B is referenced by following:

INL
VIEW - INL_ATTRIBUTES_B#

[top of page]

Table: INL_ATTRIBUTES_TL

Description: This table stores translatable data for Attributes.
Comments
Indexes
Index Type Tablespace Column
INL_ATTRIBUTES_TL_U1 UNIQUE APPS_TS_TX_IDX ATTRIBUTE_CODE
ENTITY_CODE
LANGUAGE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
ATTRIBUTE_CODE VARCHAR2 (30) Y Attribute Code
ENTITY_CODE VARCHAR2 (30) Y Entity Code
ATTRIBUTE_NAME VARCHAR2 (80) Y Attribute Name
DESCRIPTION VARCHAR2 (240)
Description
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4) Y Source Language
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y 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).
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

INL.INL_ATTRIBUTES_TL does not reference any database object

INL.INL_ATTRIBUTES_TL is referenced by following:

INL
VIEW - INL_ATTRIBUTES_TL#

[top of page]

Table: INL_CHARGE_LINES

Description: This table stores information on charges associated to Shipment components.
Comments

This table stores information on charges associated to Shipment components.

Indexes
Index Type Tablespace Column
INL_CHARGE_LINES_U1 UNIQUE APPS_TS_TX_IDX CHARGE_LINE_ID
INL_CHARGE_LINES_N1 NONUNIQUE APPS_TS_TX_IDX CHARGE_LINE_TYPE_ID
INL_CHARGE_LINES_N3 NONUNIQUE APPS_TS_TX_IDX PARTY_ID
INL_CHARGE_LINES_N4 NONUNIQUE APPS_TS_TX_IDX PARTY_SITE_ID
INL_CHARGE_LINES_N5 NONUNIQUE APPS_TS_TX_IDX PARENT_CHARGE_LINE_ID
INL_CHARGE_LINES_N6 NONUNIQUE APPS_TS_TX_IDX MATCH_ID
INL_CHARGE_LINES_N7 NONUNIQUE APPS_TS_TX_IDX MATCH_AMOUNT_ID
Columns
Name Datatype Length Mandatory Comments
CHARGE_LINE_ID NUMBER
Y Charge Line Identifier
CHARGE_LINE_NUM NUMBER
Y Charge Line Number
CHARGE_LINE_TYPE_ID NUMBER
Y Charge Line Type Identifier
LANDED_COST_FLAG VARCHAR2 (1) Y "Y" or "N" flag indicating whether the amount should be considered in the landed cost
UPDATE_ALLOWED VARCHAR2 (1)
"Y" or "N" flag indicating whether the charge can be updated
SOURCE_CODE VARCHAR2 (25)
Source Application Code the charge is being created from
PARENT_CHARGE_LINE_ID NUMBER

Parent Charge Line Identifier
ADJUSTMENT_NUM NUMBER
Y Adjustment Number
MATCH_ID NUMBER

Match Identifier
MATCH_AMOUNT_ID NUMBER

Match Amount Identifier
CHARGE_AMT NUMBER
Y Charge Amount
CURRENCY_CODE VARCHAR2 (15)
Currency Code
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
Currency Conversion Type
CURRENCY_CONVERSION_DATE DATE

Currency Conversion Date
CURRENCY_CONVERSION_RATE NUMBER

Currency Conversion Rate
PARTY_ID NUMBER

Party Identifier
PARTY_SITE_ID NUMBER

Party Site Identifier
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 Classification
TAX_CLASSIFICATION_CODE VARCHAR2 (30)
Tax Classification Code
ASSESSABLE_VALUE NUMBER

EBTAX Assessable Value
TAX_ALREADY_CALCULATED_FLAG VARCHAR2 (1)
"Y" or "N" flag indicating whether the taxes have already been calculated
SHIP_FROM_PARTY_ID NUMBER

Ship From Party Identifier
SHIP_FROM_PARTY_SITE_ID NUMBER

Ship From Party Site Identifier
SHIP_TO_ORGANIZATION_ID NUMBER

Ship To Organization Identifier
SHIP_TO_LOCATION_ID NUMBER

Ship To Location Identifier
BILL_FROM_PARTY_ID NUMBER

Bill From Party Identifier
BILL_FROM_PARTY_SITE_ID NUMBER

Bill From Party Site Identifier
BILL_TO_ORGANIZATION_ID NUMBER

Bill To Organization Identifier
BILL_TO_LOCATION_ID NUMBER

Bill To Location Identifier
POA_PARTY_ID NUMBER

Point of Order Acceptance Party Identifier
POA_PARTY_SITE_ID NUMBER

Point of Order Acceptance Party Site Identifier
POO_ORGANIZATION_ID NUMBER

Point of Order Origin Organization Identifier
POO_LOCATION_ID NUMBER

Point of Order Origin Location Identifier
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y 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).
NEW_CHARGE_AMT NUMBER

New Charge Amount
NEW_CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
New Currency Conversion Type
NEW_CURRENCY_CONVERSION_DATE DATE

New Currency Conversion Date
NEW_CURRENCY_CONVERSION_RATE NUMBER

New Currency Conversion Rate
ADJUSTMENT_TYPE_FLAG VARCHAR2 (1)
"A", "R" or "Z" flag to indicate whether the charge line will be added ("A"), removed ("R") or zeroed out ("Z") when the completed shipment is submitted

[top of page]

INL.INL_CHARGE_LINES does not reference any database object

INL.INL_CHARGE_LINES is referenced by following:

INL
VIEW - INL_CHARGE_LINES#

[top of page]

Table: INL_CONDITIONS

Description: This table stores common characteristics of COnditions.
Comments
Indexes
Index Type Tablespace Column
INL_CONDITIONS_U1 UNIQUE APPS_TS_TX_IDX CONDITION_ID
INL_CONDITIONS_N1 NONUNIQUE APPS_TS_TX_IDX RULE_ID
Columns
Name Datatype Length Mandatory Comments
CONDITION_ID NUMBER
Y Condition Identifier
RULE_ID NUMBER
Y Rule Identifier
USER_SEQUENCE NUMBER
Y User Sequence
LEFT_PARENTHESIS_CODE VARCHAR2 (1)
Left Parenthesis Code
LEFT_ENTITY_CODE VARCHAR2 (30)
Left Entity Code
LEFT_ATTRIBUTE_CODE VARCHAR2 (30) Y Left Attribute Code
LINE_OPERATOR_CODE VARCHAR2 (1) Y Line Operator Code
RIGHT_ENTITY_CODE VARCHAR2 (30)
Right Entity Code
RIGHT_ATTRIBUTE_CODE VARCHAR2 (30)
Right Attribute Code
ATTRIBUTE_CONSTANT_NUMBER NUMBER

Attribute Constant Number
ATTRIBUTE_CONSTANT_CHARACTER VARCHAR2 (240)
Attribute Constant Character
ATTRIBUTE_CONSTANT_DATE DATE

Attribute Constant Date
ATTRIBUTE_EXPRESSION VARCHAR2 (240)
Attribute Expression
RIGHT_PARENTHESIS_CODE VARCHAR2 (1)
Right Paranthesis Code
LOGICAL_OPERATOR_CODE VARCHAR2 (1)
Logical Operator Code
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y 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).

[top of page]

INL.INL_CONDITIONS does not reference any database object

INL.INL_CONDITIONS is referenced by following:

INL
VIEW - INL_CONDITIONS#

[top of page]

Table: INL_ENTITIES_B

Description: This table stores common characteristics of Entities.
Comments
Indexes
Index Type Tablespace Column
INL_ENTITIES_B_U1 UNIQUE APPS_TS_TX_IDX ENTITY_CODE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
ENTITY_CODE VARCHAR2 (30) Y Entity Code
TABLE_NAME VARCHAR2 (30)
Table Name
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y 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).
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

INL.INL_ENTITIES_B does not reference any database object

INL.INL_ENTITIES_B is referenced by following:

INL
VIEW - INL_ENTITIES_B#

[top of page]

Table: INL_ENTITIES_TL

Description: This table stores translatable data for Entities.
Comments
Indexes
Index Type Tablespace Column
INL_ENTITIES_TL_U1 UNIQUE APPS_TS_TX_IDX ENTITY_CODE
LANGUAGE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
ENTITY_CODE VARCHAR2 (30) Y Entity Code
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4) Y Source Language
ENTITY_NAME VARCHAR2 (80) Y Entity Name
DESCRIPTION VARCHAR2 (240)
Description
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y 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).
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

INL.INL_ENTITIES_TL does not reference any database object

INL.INL_ENTITIES_TL is referenced by following:

INL
VIEW - INL_ENTITIES_TL#

[top of page]

Table: INL_INTERFACE_ERRORS

Description: This table stores information on errors occurred during LCM Open Interface Processor.
Comments

This table stores information on errors occurred during LCM Open Interface Processor.

Indexes
Index Type Tablespace Column
INL_INTERFACE_ERRORS_N1 NONUNIQUE APPS_TS_TX_IDX PARENT_TABLE_NAME
PARENT_TABLE_ID
Columns
Name Datatype Length Mandatory Comments
INTERFACE_ERROR_ID NUMBER
Y Interface Error Identifier
PARENT_TABLE_NAME VARCHAR2 (30) Y Name of the table the error refers to: INL_SHIP_HEADERS_INT, INL_SHIP_LINES_INT, INL_MATCHES_INT, INL_MATCH_AMOUNTS_INT
PARENT_TABLE_ID NUMBER
Y Identifier of the table line the error refers to: SHIP_HEADER_INT_ID, SHIP_LINE_INT_ID, MATCH_INT_ID, MATCH_AMOUNT_INT_ID
COLUMN_NAME VARCHAR2 (30)
Column Name
COLUMN_VALUE VARCHAR2 (4000)
Column Value
PROCESSING_DATE DATE

Processing Date
ERROR_MESSAGE_NAME VARCHAR2 (30)
Error Message Name
ERROR_MESSAGE VARCHAR2 (2000)
Error Message
TOKEN1_NAME VARCHAR2 (100)
1st token name of the message
TOKEN1_VALUE VARCHAR2 (200)
1st token value of the message
TOKEN2_NAME VARCHAR2 (100)
2nd token name of the message
TOKEN2_VALUE VARCHAR2 (200)
2nd token value of the message
TOKEN3_NAME VARCHAR2 (100)
3rd token name of the message
TOKEN3_VALUE VARCHAR2 (200)
3rd token value of the message
TOKEN4_NAME VARCHAR2 (100)
4th token name of the message
TOKEN4_VALUE VARCHAR2 (200)
4th token value of the message
TOKEN5_NAME VARCHAR2 (100)
5th token name of the message
TOKEN5_VALUE VARCHAR2 (200)
5th token value of the message
TOKEN6_NAME VARCHAR2 (100)
6th token name of the message
TOKEN6_VALUE VARCHAR2 (200)
6th token value of the message
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y 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_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).
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).

[top of page]

INL.INL_INTERFACE_ERRORS does not reference any database object

INL.INL_INTERFACE_ERRORS is referenced by following:

INL
VIEW - INL_INTERFACE_ERRORS#

[top of page]

Table: INL_MATCHES

Description: This table stores actual amounts and the shipment components they refer to, to be used in actual landed cost calculation.
Comments

This table stores actual amounts and the shipment components they refer to, to be used in actual landed cost calculation.

Indexes
Index Type Tablespace Column
INL_MATCHES_U1 UNIQUE APPS_TS_TX_IDX MATCH_ID
INL_MATCHES_N1 NONUNIQUE APPS_TS_TX_IDX FROM_PARENT_TABLE_NAME
FROM_PARENT_TABLE_ID
INL_MATCHES_N2 NONUNIQUE APPS_TS_TX_IDX MATCH_AMOUNT_ID
INL_MATCHES_N3 NONUNIQUE APPS_TS_TX_IDX TO_PARENT_TABLE_NAME
TO_PARENT_TABLE_ID
INL_MATCHES_N4 NONUNIQUE APPS_TS_TX_IDX FROM_PARENT_TABLE_NAME
FROM_PARENT_TABLE_ID
TO_PARENT_TABLE_NAME
TO_PARENT_TABLE_ID
INL_MATCHES_N5 NONUNIQUE APPS_TS_TX_IDX SHIP_HEADER_ID
ADJUSTMENT_NUM
INL_MATCHES_N6 NONUNIQUE APPS_TS_TX_IDX PARENT_MATCH_ID
MATCH_TYPE_CODE
Columns
Name Datatype Length Mandatory Comments
MATCH_ID NUMBER
Y Match Identifier
MATCH_TYPE_CODE VARCHAR2 (30) Y Match Type Code
SHIP_HEADER_ID NUMBER

Shipment Identifier
FROM_PARENT_TABLE_NAME VARCHAR2 (30)
Identifier of the table line the match comes from.
FROM_PARENT_TABLE_ID NUMBER

Identifier of the table line the match comes from.
TO_PARENT_TABLE_NAME VARCHAR2 (30)
Name of the table the match goes to: INL_SHIP_LINES
TO_PARENT_TABLE_ID NUMBER

Identifier of the table line the match goes to: SHIP_LINE_ID
PARENT_MATCH_ID NUMBER

Parent Match Identifier
MATCHED_QTY NUMBER

Matched Quantity
MATCHED_UOM_CODE VARCHAR2 (3)
Matched Unit of Measure Code
MATCHED_AMT NUMBER

Matched Amount
MATCHED_CURR_CODE VARCHAR2 (15)
Matched Currency Code
MATCHED_CURR_CONVERSION_TYPE VARCHAR2 (30)
Match Currency Conversion Type
MATCHED_CURR_CONVERSION_DATE DATE

Match Currency Conversion Date
MATCHED_CURR_CONVERSION_RATE NUMBER

Match Currency Conversion Rate
ADJ_ALREADY_GENERATED_FLAG VARCHAR2 (1) Y "Y" or "N" flag indicating whether the match has already generated adjustments
REPLACE_ESTIM_QTY_FLAG VARCHAR2 (1) Y "Y" or "N" flag indicating whether the quantities should be also adjusted beside the amounts.
EXISTING_MATCH_INFO_FLAG VARCHAR2 (1) Y "Y" or "N" flag indicating whether the match corresponds to data already matched (match update)
CHARGE_LINE_TYPE_ID NUMBER

Charge Line Type Identifier
PARTY_ID NUMBER

Party Identifier
PARTY_SITE_ID NUMBER

Party Site Identifier
TAX_CODE VARCHAR2 (30)
Tax Code
NREC_TAX_AMT NUMBER

Non Recoverable Tax Amount
TAX_AMT_INCLUDED_FLAG VARCHAR2 (1)
"Y" or "N" flag indicating whether the tax is included to the unit price.
MATCH_AMOUNT_ID NUMBER

Match Amount Identifier
MATCH_INT_ID NUMBER

Match Interface Identifier
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).
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y 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).
ADJ_GROUP_DATE DATE

Group date for adjustment creation
ADJUSTMENT_NUM NUMBER

Number of the Adjustment generated by this match

[top of page]

INL.INL_MATCHES does not reference any database object

INL.INL_MATCHES is referenced by following:

INL
VIEW - INL_MATCHES#

[top of page]

Table: INL_MATCHES_INT

Description: This table stores Open Interface data for Matches.
Comments

This table stores Open Interface data for Matches.

Indexes
Index Type Tablespace Column
INL_MATCHES_INT_U1 UNIQUE APPS_TS_TX_IDX MATCH_INT_ID
INL_MATCHES_INT_N1 NONUNIQUE APPS_TS_TX_IDX REQUEST_ID
PROCESSING_STATUS_CODE
GROUP_ID
Columns
Name Datatype Length Mandatory Comments
MATCH_INT_ID NUMBER
Y Match Interface Identifier
GROUP_ID NUMBER
Y Open Interface Group Identifier
PROCESSING_STATUS_CODE VARCHAR2 (25) Y Processing Status Code
TRANSACTION_TYPE VARCHAR2 (25) Y Open Interface Transaction Type
MATCH_TYPE_CODE VARCHAR2 (30) Y Match Type Code
FROM_PARENT_TABLE_NAME VARCHAR2 (30)
Identifier of the table line the match comes from
FROM_PARENT_TABLE_ID NUMBER

Identifier of the table line the match comes from
TO_PARENT_TABLE_NAME VARCHAR2 (30)
Name of the table the match goes to: INL_SHIP_LINES
TO_PARENT_TABLE_ID NUMBER

Identifier of the table line the match goes to: SHIP_LINE_ID
MATCHED_QTY NUMBER

Matched Quantity
MATCHED_UOM_CODE VARCHAR2 (3)
Matched Unit of Measure Code
MATCHED_AMT NUMBER

Matched Amount
MATCHED_CURR_CODE VARCHAR2 (15)
Matched Currency Code
MATCHED_CURR_CONVERSION_TYPE VARCHAR2 (30)
Match Currency Conversion Type
MATCHED_CURR_CONVERSION_DATE DATE

Match Currency Conversion Date
MATCHED_CURR_CONVERSION_RATE NUMBER

Match Currency Conversion Rate
REPLACE_ESTIM_QTY_FLAG VARCHAR2 (1) Y "Y" or "N" flag indicating whether the quantities should be also adjusted beside the amounts.
CHARGE_LINE_TYPE_ID NUMBER

Charge Line Type Identifier
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
TAX_CODE VARCHAR2 (30)
Tax Code
NREC_TAX_AMT NUMBER

Non Recoverable Tax Amount
TAX_AMT_INCLUDED_FLAG VARCHAR2 (1)
"Y" or "N" flag indicating whether the quantities should be also adjusted beside the amounts.
MATCH_AMOUNT_INT_ID NUMBER

CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y 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).
ADJ_GROUP_DATE DATE

Group date for adjustment creation
MATCH_AMOUNTS_FLAG VARCHAR2 (1)
"Y" or "N" flag indicating whether the match should generated record in inl_match_amount table

[top of page]

INL.INL_MATCHES_INT does not reference any database object

INL.INL_MATCHES_INT is referenced by following:

INL
VIEW - INL_MATCHES_INT#

[top of page]

Table: INL_MATCH_AMOUNTS

Description: This table stores actual charge amounts, grouped by cost factor, and the shipment components they refer to, to be used as actual charges, in actual landed cost calculation.
Comments

This table stores actual charge amounts, grouped by cost factor, and the shipment components they refer to, to be used as actual charges, in actual landed cost calculation.

Indexes
Index Type Tablespace Column
INL_MATCH_AMOUNTS_U1 UNIQUE APPS_TS_TX_IDX MATCH_AMOUNT_ID
INL_MATCH_AMOUNTS_N1 NONUNIQUE APPS_TS_TX_IDX MATCH_AMOUNT_INT_ID
Columns
Name Datatype Length Mandatory Comments
MATCH_AMOUNT_ID NUMBER
Y Match Amount Identifier
MATCHED_AMT NUMBER
Y Matched Amount
MATCHED_CURR_CODE VARCHAR2 (15) Y Matched Currency Code
MATCHED_CURR_CONVERSION_TYPE VARCHAR2 (30)
Match Currency Conversion Type
MATCHED_CURR_CONVERSION_DATE DATE

Match Currency Conversion Date
MATCHED_CURR_CONVERSION_RATE NUMBER

Match Currency Conversion Rate
MATCH_AMOUNT_INT_ID NUMBER

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).
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y 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).
ADJ_GROUP_DATE DATE

Group date for adjustment creation
GROUP_ID NUMBER

Match Interface Group Identifier
CHARGE_LINE_TYPE_ID NUMBER

Charge Line Type Identifier
TAX_CODE VARCHAR2 (30)
Tax Code
NREC_TAX_AMT NUMBER

Non Recoverable Tax Amount

[top of page]

INL.INL_MATCH_AMOUNTS does not reference any database object

INL.INL_MATCH_AMOUNTS is referenced by following:

INL
VIEW - INL_MATCH_AMOUNTS#

[top of page]

Table: INL_MATCH_AMOUNTS_INT

Description: This table stores Open Interface data for matches between actual and estimated charge amounts of a Landed Cost Shipment, grouped by Charge Line Type.
Comments
Indexes
Index Type Tablespace Column
INL_MATCH_AMOUNTS_INT_U1 UNIQUE APPS_TS_TX_IDX MATCH_AMOUNT_INT_ID
Columns
Name Datatype Length Mandatory Comments
MATCH_AMOUNT_INT_ID NUMBER
Y
GROUP_ID NUMBER
Y
PROCESSING_STATUS_CODE VARCHAR2 (25) Y
TRANSACTION_TYPE VARCHAR2 (25) Y
MATCHED_AMT NUMBER
Y
MATCHED_CURR_CODE VARCHAR2 (15) Y
MATCHED_CURR_CONVERSION_TYPE VARCHAR2 (30)
MATCHED_CURR_CONVERSION_DATE DATE

MATCHED_CURR_CONVERSION_RATE NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

PROGRAM_APPLICATION_ID NUMBER

REQUEST_ID NUMBER

CREATED_BY NUMBER
Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER
Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER

[top of page]

INL.INL_MATCH_AMOUNTS_INT does not reference any database object

INL.INL_MATCH_AMOUNTS_INT is referenced by following:

INL
VIEW - INL_MATCH_AMOUNTS_INT#

[top of page]

Table: INL_PARAMETERS

Description: This table stores the general LCM setup options by Inventory Organization.
Comments

This table stores the general LCM setup options by Inventory Organization.

Indexes
Index Type Tablespace Column
INL_PARAMETERS_U1 UNIQUE APPS_TS_TX_IDX ORGANIZATION_ID
INL_PARAMETERS_N1 NONUNIQUE APPS_TS_TX_IDX RULE_ID
Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER
Y Inventory Organization Identifier
USER_DEFINED_SHIP_NUM_CODE VARCHAR2 (25)
Lookup to determine when Shipment Number is filled manually or automatically
MANUAL_SHIP_NUM_TYPE VARCHAR2 (25)
Lookup to determine when Shipment Number could have Numeric and Alphanumeric values
NEXT_SHIP_NUM NUMBER
Y Next Shipment Number
PO_PRICE_TOLER_PERC NUMBER

Tolerance Percentual against PO Price
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y 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).
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
RULE_ID NUMBER

Rule Identifier

[top of page]

INL.INL_PARAMETERS does not reference any database object

INL.INL_PARAMETERS is referenced by following:

INL
VIEW - INL_PARAMETERS#

[top of page]

Table: INL_RULES_B

Description: This table stores common characteristics of Rules.
Comments
Indexes
Index Type Tablespace Column
INL_RULES_B_U1 UNIQUE APPS_TS_TX_IDX RULE_ID
Columns
Name Datatype Length Mandatory Comments
RULE_ID NUMBER
Y Rule Identifier
PACKAGE_NAME VARCHAR2 (100)
Package Name
USAGE_CODE VARCHAR2 (30) Y Usage Code
ENABLED_FLAG VARCHAR2 (1)
Enabled Flag
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y 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).

[top of page]

INL.INL_RULES_B does not reference any database object

INL.INL_RULES_B is referenced by following:

INL
VIEW - INL_RULES_B#

[top of page]

Table: INL_RULES_TL

Description: This table stores translatable data for Rules.
Comments
Indexes
Index Type Tablespace Column
INL_RULES_TL_U1 UNIQUE APPS_TS_TX_IDX RULE_ID
LANGUAGE
INL_RULES_TL_U2 UNIQUE APPS_TS_TX_IDX RULE_NAME
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
RULE_ID NUMBER
Y Rule Identifier
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4) Y Source Language
RULE_NAME VARCHAR2 (30) Y Rule Name
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y 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).

[top of page]

INL.INL_RULES_TL does not reference any database object

INL.INL_RULES_TL is referenced by following:

INL
VIEW - INL_RULES_TL#

[top of page]

Table: INL_SHIP_HEADERS_ALL

Description: This table stores header information on Shipments.
Comments

This table stores header information on Shipments.

Indexes
Index Type Tablespace Column
INL_SHIP_HEADERS_ALL_U1 UNIQUE APPS_TS_TX_IDX SHIP_HEADER_ID
INL_SHIP_HEADERS_ALL_U2 UNIQUE APPS_TS_TX_IDX ORGANIZATION_ID
SHIP_NUM
INL_SHIP_HEADERS_ALL_N1 NONUNIQUE APPS_TS_TX_IDX SHIP_TYPE_ID
INL_SHIP_HEADERS_ALL_N2 NONUNIQUE APPS_TS_TX_IDX LEGAL_ENTITY_ID
INL_SHIP_HEADERS_ALL_N3 NONUNIQUE APPS_TS_TX_IDX LOCATION_ID
INL_SHIP_HEADERS_ALL_N4 NONUNIQUE APPS_TS_TX_IDX SIMULATION_ID
Columns
Name Datatype Length Mandatory Comments
SHIP_HEADER_ID NUMBER
Y Shipment Identifier
SHIP_NUM VARCHAR2 (25) Y Shipment Number
SHIP_DATE DATE
Y Shipment Date
SHIP_TYPE_ID NUMBER
Y Shipment Type Identifier
SHIP_STATUS_CODE VARCHAR2 (30) Y 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
Y Legal Entity Identifier
ORGANIZATION_ID NUMBER
Y Inventory Organization Identifier
LOCATION_ID NUMBER

Location Identifier
ORG_ID NUMBER
Y 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
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y 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

[top of page]

INL.INL_SHIP_HEADERS_ALL does not reference any database object

INL.INL_SHIP_HEADERS_ALL is referenced by following:

INL
VIEW - INL_SHIP_HEADERS_ALL#

[top of page]

Table: INL_SHIP_HEADERS_INT

Description: This table stores Open Interface data for Shipment Headers.
Comments

This table stores Open Interface data for Shipment Headers.

Indexes
Index Type Tablespace Column
INL_SHIP_HEADERS_INT_U1 UNIQUE APPS_TS_TX_IDX SHIP_HEADER_INT_ID
INL_SHIP_HEADERS_INT_N1 NONUNIQUE APPS_TS_TX_IDX PROCESSING_STATUS_CODE
GROUP_ID
Columns
Name Datatype Length Mandatory Comments
SHIP_HEADER_INT_ID NUMBER
Y Shipment Interface Identifier
GROUP_ID NUMBER
Y Open Interface Group Identifier
PROCESSING_STATUS_CODE VARCHAR2 (25) Y Processing Status Code
TRANSACTION_TYPE VARCHAR2 (25)
Open Interface Transaction Type
INTERFACE_SOURCE_CODE VARCHAR2 (25) Y 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
VALIDATION_FLAG VARCHAR2 (1) Y "Y" or "N" flag indicating whether the record should be validated
SHIP_NUM VARCHAR2 (25)
Shipment Number
SHIP_DATE DATE

Shipment Date
SHIP_TYPE_ID NUMBER

Shipment Type Identifier
SHIP_TYPE_CODE VARCHAR2 (15)
Shipment Type Code
LEGAL_ENTITY_ID NUMBER

LEGAL_ENTITY_NAME VARCHAR2 (50)
ORGANIZATION_ID NUMBER

Inventory Organization Identifier
ORGANIZATION_CODE VARCHAR2 (3)
Inventory Organization Code
LOCATION_ID NUMBER

Location Identifier
LOCATION_CODE VARCHAR2 (60)
Location Code
ORG_ID NUMBER

TAXATION_COUNTRY VARCHAR2 (30)
Specifies the country for taxation for tax calculation purposes
DOCUMENT_SUB_TYPE VARCHAR2 (150)
EBTAX Header level field
SHIP_HEADER_ID NUMBER

Shipment Identifier
LAST_TASK_CODE VARCHAR2 (25)
Last Task to be executed by the LCM Open Interface Processor
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y 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 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

[top of page]

INL.INL_SHIP_HEADERS_INT does not reference any database object

INL.INL_SHIP_HEADERS_INT is referenced by following:

INL
VIEW - INL_SHIP_HEADERS_INT#

[top of page]

Table: INL_SHIP_HOLDS

Description: This table stores information on holds occurred during LCM Shipment validation process.
Comments

This table stores information on holds occurred during LCM Shipment validation process.

Indexes
Index Type Tablespace Column
INL_SHIP_HOLDS_U1 UNIQUE APPS_TS_TX_IDX SHIP_HOLD_ID
INL_SHIP_HOLDS_N1 NONUNIQUE APPS_TS_TX_IDX SHIP_HEADER_ID
INL_SHIP_HOLDS_N2 NONUNIQUE APPS_TS_TX_IDX SHIP_LINE_ID
Columns
Name Datatype Length Mandatory Comments
SHIP_HOLD_ID NUMBER
Y Shipment Hold Identifier
SHIP_HEADER_ID NUMBER

Shipment Identifier
SHIP_LINE_ID NUMBER

Shipment Line Identifier
CHARGE_LINE_ID NUMBER

Charge Line Identifier
TABLE_NAME VARCHAR2 (30)
Table Name
COLUMN_NAME VARCHAR2 (30)
Column Name
COLUMN_VALUE VARCHAR2 (4000)
Column Value
PROCESSING_DATE DATE

Processing Date
ERROR_MESSAGE VARCHAR2 (2000)
Error Message
ERROR_MESSAGE_NAME VARCHAR2 (30)
Error Message Name
TOKEN1_NAME VARCHAR2 (100)
1st token name of the message
TOKEN1_VALUE VARCHAR2 (200)
1st token value of the message
TOKEN2_NAME VARCHAR2 (100)
2nd token name of the message
TOKEN2_VALUE VARCHAR2 (200)
2nd token value of the message
TOKEN3_NAME VARCHAR2 (100)
3rd token name of the message
TOKEN3_VALUE VARCHAR2 (200)
3rd token value of the message
TOKEN4_NAME VARCHAR2 (100)
4th token name of the message
TOKEN4_VALUE VARCHAR2 (200)
4th token value of the message
TOKEN5_NAME VARCHAR2 (100)
5th token name of the message
TOKEN5_VALUE VARCHAR2 (200)
5th token value of the message
TOKEN6_NAME VARCHAR2 (100)
6th token name of the message
TOKEN6_VALUE VARCHAR2 (200)
6th token value of the message
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y 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_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).
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).

[top of page]

INL.INL_SHIP_HOLDS does not reference any database object

INL.INL_SHIP_HOLDS is referenced by following:

INL
VIEW - INL_SHIP_HOLDS#

[top of page]

Table: INL_SHIP_LINES_ALL

Description: This table stores information on Shipment Lines.
Comments

This table stores information on Shipment Lines.

Indexes
Index Type Tablespace Column
INL_SHIP_LINES_ALL_U1 UNIQUE APPS_TS_TX_IDX SHIP_LINE_ID
INL_SHIP_LINES_ALL_N1 NONUNIQUE APPS_TS_TX_IDX SHIP_LINE_GROUP_ID
SHIP_HEADER_ID
SHIP_LINE_NUM
INL_SHIP_LINES_ALL_N2 NONUNIQUE APPS_TS_TX_IDX SHIP_LINE_TYPE_ID
INL_SHIP_LINES_ALL_N3 NONUNIQUE APPS_TS_TX_IDX PARENT_SHIP_LINE_ID
INL_SHIP_LINES_ALL_N4 NONUNIQUE APPS_TS_TX_IDX SHIP_HEADER_ID
ADJUSTMENT_NUM
INL_SHIP_LINES_ALL_N5 NONUNIQUE APPS_TS_TX_IDX SHIP_LINE_SOURCE_ID
INL_SHIP_LINES_ALL_N6 NONUNIQUE APPS_TS_TX_IDX INVENTORY_ITEM_ID
INL_SHIP_LINES_ALL_N7 NONUNIQUE APPS_TS_TX_IDX MATCH_ID
Columns
Name Datatype Length Mandatory Comments
SHIP_HEADER_ID NUMBER
Y Shipment Identifier
SHIP_LINE_GROUP_ID NUMBER
Y Line Group Identifier
SHIP_LINE_ID NUMBER
Y Shipment Line Identifier
SHIP_LINE_NUM NUMBER
Y Shipment Line Number
SHIP_LINE_TYPE_ID NUMBER
Y Shipment Line Type Identifier
SHIP_LINE_SRC_TYPE_CODE VARCHAR2 (30)
Source Type Code, taken from lookup INL_SHIP_LINE_SRC_TYPES
SHIP_LINE_SOURCE_ID NUMBER

Source Identifier, according to the Source Type Code
PARENT_SHIP_LINE_ID NUMBER

Parent Shipment Line Identifier
ADJUSTMENT_NUM NUMBER
Y Adjustment Number
MATCH_ID NUMBER

Match Identifier
CURRENCY_CODE VARCHAR2 (15) Y 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) Y "Y" or "N" flag indicating whether the amount should be considered in the landed cost
ALLOCATION_ENABLED_FLAG VARCHAR2 (1) Y "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 Classification
TAX_CLASSIFICATION_CODE VARCHAR2 (30)
Tax Classification Code
ASSESSABLE_VALUE NUMBER

EBTAX Assessable Value
TAX_ALREADY_CALCULATED_FLAG VARCHAR2 (1)
"Y" or "N" flag indicating whether the taxes have already been calculated
SHIP_FROM_PARTY_ID NUMBER

Ship From Party Identifier
SHIP_FROM_PARTY_SITE_ID NUMBER

Ship From Party Site Identifier
SHIP_TO_ORGANIZATION_ID NUMBER

Ship To Organization Identifier
SHIP_TO_LOCATION_ID NUMBER

Ship To Location Identifier
BILL_FROM_PARTY_ID NUMBER

Bill From Party Identifier
BILL_FROM_PARTY_SITE_ID NUMBER

Bill From Party Site Identifier
BILL_TO_ORGANIZATION_ID NUMBER

Bill To Organization Identifier
BILL_TO_LOCATION_ID NUMBER

Bill To Location Identifier
POA_PARTY_ID NUMBER

Point of Order Acceptance Party Identifier
POA_PARTY_SITE_ID NUMBER

Point of Order Acceptance Party Site Identifier
POO_ORGANIZATION_ID NUMBER

Point of Order Origin Organization Identifier
POO_LOCATION_ID NUMBER

Point of Order Origin Location Identifier
ORG_ID NUMBER
Y Organization Identifier
SHIP_LINE_INT_ID NUMBER

Shipment Line Interface 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
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y 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
NRQ_ZERO_EXCEPTION_FLAG VARCHAR2 (1)
"Y" or "N" flag indicating if net receiving quantity is zero
NEW_TXN_UNIT_PRICE NUMBER

New Transaction Unit Price
NEW_CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
New Currency Conversion Type
NEW_CURRENCY_CONVERSION_DATE DATE

New Currency Conversion Date
NEW_CURRENCY_CONVERSION_RATE NUMBER

New Currency Conversion Rate

[top of page]

INL.INL_SHIP_LINES_ALL does not reference any database object

INL.INL_SHIP_LINES_ALL is referenced by following:

INL
VIEW - INL_SHIP_LINES_ALL#

[top of page]

Table: INL_SHIP_LINES_INT

Description: This table stores Open Interface data for Shipment Lines
Comments

This table stores Open Interface data for Shipment Lines

Indexes
Index Type Tablespace Column
INL_SHIP_LINES_INT_U1 UNIQUE APPS_TS_TX_IDX SHIP_LINE_INT_ID
INL_SHIP_LINES_INT_N1 NONUNIQUE APPS_TS_TX_IDX SHIP_HEADER_INT_ID
Columns
Name Datatype Length Mandatory Comments
SHIP_HEADER_INT_ID NUMBER
Y Shipment Interface Identifier
SHIP_LINE_INT_ID NUMBER
Y Shipment Line Interface Identifier
GROUP_ID NUMBER

No longer used
PROCESSING_STATUS_CODE VARCHAR2 (25) Y Processing Status Code
VALIDATION_FLAG VARCHAR2 (1)
No longer used
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)
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)
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)
"Y" or "N" flag indicating whether the amount should be considered in the landed cost
ALLOCATION_ENABLED_FLAG VARCHAR2 (1)
"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 Classification
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

No longer used
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
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y 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 definition column.
ATTRIBUTE1_LG VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2_LG VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3_LG VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4_LG VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5_LG VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6_LG VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7_LG VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8_LG VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9_LG VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10_LG VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11_LG VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12_LG VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13_LG VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14_LG VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15_LG VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE_CATEGORY_SL VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1_SL VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2_SL VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3_SL VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4_SL VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5_SL VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6_SL VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7_SL VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8_SL VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9_SL VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10_SL VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11_SL VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12_SL VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13_SL VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14_SL VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15_SL VARCHAR2 (150)
Descriptive flexfield segment
SHIP_LINE_GROUP_NUM NUMBER

Shipment Line Group Number
INVENTORY_ITEM_NAME VARCHAR2 (80)
Inventory Item concatenated segments
SHIP_LINE_GROUP_ID NUMBER

Shipment Line Group Identifier

[top of page]

INL.INL_SHIP_LINES_INT does not reference any database object

INL.INL_SHIP_LINES_INT is referenced by following:

INL
VIEW - INL_SHIP_LINES_INT#

[top of page]

Table: INL_SHIP_LINE_GROUPS

Description: This table stores attributes common to all Shipment Lines below it
Comments

This table stores attributes common to all Shipment Lines below it

Indexes
Index Type Tablespace Column
INL_SHIP_LINE_GROUPS_U1 UNIQUE APPS_TS_TX_IDX SHIP_LINE_GROUP_ID
INL_SHIP_LINE_GROUPS_N1 NONUNIQUE APPS_TS_TX_IDX SHIP_HEADER_ID
INL_SHIP_LINE_GROUPS_N2 NONUNIQUE APPS_TS_TX_IDX PARTY_ID
INL_SHIP_LINE_GROUPS_N3 NONUNIQUE APPS_TS_TX_IDX PARTY_SITE_ID
INL_SHIP_LINE_GROUPS_N4 NONUNIQUE APPS_TS_TX_IDX SOURCE_ORGANIZATION_ID
Columns
Name Datatype Length Mandatory Comments
SHIP_LINE_GROUP_ID NUMBER
Y Line Group Identifier
SHIP_LINE_GROUP_REFERENCE VARCHAR2 (30)
Line Group Reference
SHIP_HEADER_ID NUMBER
Y Shipment Identifier
SHIP_LINE_GROUP_NUM NUMBER
Y Line Group Number
SRC_TYPE_CODE VARCHAR2 (30) Y Source Type Code
PARTY_ID NUMBER

Party Identifier
PARTY_SITE_ID NUMBER

Party Site Identifier
SOURCE_ORGANIZATION_ID NUMBER

Source Inventory Organization Identifier
SHIP_LINE_INT_ID NUMBER

Shipment Line Interface 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
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y 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

[top of page]

INL.INL_SHIP_LINE_GROUPS does not reference any database object

INL.INL_SHIP_LINE_GROUPS is referenced by following:

INL
VIEW - INL_SHIP_LINE_GROUPS#

[top of page]

Table: INL_SHIP_LINE_TYPES_B

Description: This table stores common characteristics of Shipment Lines.
Comments

This table stores common characteristics of Shipment Lines.

Indexes
Index Type Tablespace Column
INL_SHIP_LINE_TYPES_B_U1 UNIQUE APPS_TS_TX_IDX SHIP_LINE_TYPE_ID
INL_SHIP_LINE_TYPES_B_U2 UNIQUE APPS_TS_TX_IDX SHIP_LINE_TYPE_CODE
Columns
Name Datatype Length Mandatory Comments
SHIP_LINE_TYPE_ID NUMBER
Y Shipment Line Type Identifier
SHIP_LINE_TYPE_CODE VARCHAR2 (15) Y Shipment Line Type Code
DFLT_LANDED_COST_FLAG VARCHAR2 (1) Y "Y" or "N" flag indicating whether the amounts of the line should be considered in the landed cost
DFLT_ALLOCATION_ENABLED_FLAG VARCHAR2 (1) Y "Y" or "N" flag indicating whether the amounts of the line are associable
ACTIVE_FROM_DATE DATE
Y Active From Date
ACTIVE_TO_DATE DATE

Active To Date
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y 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).
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

[top of page]

INL.INL_SHIP_LINE_TYPES_B does not reference any database object

INL.INL_SHIP_LINE_TYPES_B is referenced by following:

INL
VIEW - INL_SHIP_LINE_TYPES_B#

[top of page]

Table: INL_SHIP_LINE_TYPES_TL

Description: This table stores translatable data for Shipment Line Types.
Comments

This table stores translatable data for Shipment Line Types.

Indexes
Index Type Tablespace Column
INL_SHIP_LINE_TYPES_TL_U1 UNIQUE APPS_TS_TX_IDX SHIP_LINE_TYPE_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
SHIP_LINE_TYPE_ID NUMBER
Y Shipment Line Type Identifier
LANGUAGE VARCHAR2 (4) Y Translated language
SOURCE_LANG VARCHAR2 (4) Y User environment language
SHIP_LINE_TYPE_NAME VARCHAR2 (30) Y Shipment Line Type Name
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y 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).

[top of page]

INL.INL_SHIP_LINE_TYPES_TL does not reference any database object

INL.INL_SHIP_LINE_TYPES_TL is referenced by following:

INL
VIEW - INL_SHIP_LINE_TYPES_TL#

[top of page]

Table: INL_SHIP_TYPES_B

Description: This table stores common characteristics of Shipments.
Comments

This table stores common characteristics of Shipments.

Indexes
Index Type Tablespace Column
INL_SHIP_TYPES_B_U1 UNIQUE APPS_TS_TX_IDX SHIP_TYPE_ID
INL_SHIP_TYPES_B_U2 UNIQUE APPS_TS_TX_IDX SHIP_TYPE_CODE
Columns
Name Datatype Length Mandatory Comments
SHIP_TYPE_ID NUMBER
Y Shipment Type Identifier
SHIP_TYPE_CODE VARCHAR2 (15) Y Shipment Type Code
TRD_PTIES_ALWD_CODE VARCHAR2 (1) Y Third Parties Allowed Code, taken from lookup INL_3RD_PARTIES_ALLOWED
ACTIVE_FROM_DATE DATE
Y Active From Date
ACTIVE_TO_DATE DATE

Active To Date
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y 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).
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

[top of page]

INL.INL_SHIP_TYPES_B does not reference any database object

INL.INL_SHIP_TYPES_B is referenced by following:

INL
VIEW - INL_SHIP_TYPES_B#

[top of page]

Table: INL_SHIP_TYPES_TL

Description: This table stores translatable data for Shipment Types.
Comments

This table stores translatable data for Shipment Types.

Indexes
Index Type Tablespace Column
INL_SHIP_TYPES_TL_U1 UNIQUE APPS_TS_TX_IDX SHIP_TYPE_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
SHIP_TYPE_ID NUMBER
Y Shipment Type Identifier
LANGUAGE VARCHAR2 (4) Y Translated language
SOURCE_LANG VARCHAR2 (4) Y User environment language
SHIP_TYPE_NAME VARCHAR2 (30) Y Shipment Type Name
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y 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).

[top of page]

INL.INL_SHIP_TYPES_TL does not reference any database object

INL.INL_SHIP_TYPES_TL is referenced by following:

INL
VIEW - INL_SHIP_TYPES_TL#

[top of page]

Table: INL_SIMULATIONS

Description: This table is for to grouping the several simulated shipments that may be generated for a given source document and revision
Comments

This table is for to grouping the several simulated shipments that may be generated for a given source document and revision

Indexes
Index Type Tablespace Column
INL_SIMULATIONS_U1 UNIQUE APPS_TS_TX_IDX SIMULATION_ID
INL_SIMULATIONS_N1 NONUNIQUE APPS_TS_TX_IDX PARENT_TABLE_NAME
PARENT_TABLE_ID
PARENT_TABLE_REVISION_NUM
INL_SIMULATIONS_N2 NONUNIQUE APPS_TS_TX_IDX VENDOR_ID
INL_SIMULATIONS_N3 NONUNIQUE APPS_TS_TX_IDX VENDOR_SITE_ID
INL_SIMULATIONS_N4 NONUNIQUE APPS_TS_TX_IDX FREIGHT_CODE
INL_SIMULATIONS_N5 NONUNIQUE APPS_TS_TX_IDX ORG_ID
Columns
Name Datatype Length Mandatory Comments
SIMULATION_ID NUMBER
Y Simulation identifier
FIRMED_FLAG VARCHAR2 (1) Y "Y" or "N" flag indicating whether the simulation is firmed
PARENT_TABLE_NAME VARCHAR2 (30) Y Name of the table the simulation belongs to: PO_HEADERS
PARENT_TABLE_ID NUMBER
Y Identifier of the table line the simulation belongs to: PO_HEADER_ID
PARENT_TABLE_REVISION_NUM NUMBER
Y Revision of the table line the simulation belongs to: REVISION_NUM
VERSION_NUM NUMBER
Y Simulation Version
VENDOR_ID NUMBER

Supplier unique identifier (References PO_VENDORS.vendor_id)
VENDOR_SITE_ID NUMBER

Supplier site unique identifier (References PO_VENDOR_SITES_ALL.vendor_site_id)
FREIGHT_CODE VARCHAR2 (25)
Freight code
ORG_ID NUMBER
Y Operating Unit identifier
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID)
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID)
LAST_UPDATE_DATE DATE
Y 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

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

[top of page]

INL.INL_SIMULATIONS does not reference any database object

INL.INL_SIMULATIONS is referenced by following:

INL
VIEW - INL_SIMULATIONS#

[top of page]

Table: INL_TAX_LINES

Description: This table stores information on taxes associated to Shipment components.
Comments

This table stores information on taxes associated to Shipment components.

Indexes
Index Type Tablespace Column
INL_TAX_LINES_U1 UNIQUE APPS_TS_TX_IDX TAX_LINE_ID
INL_TAX_LINES_N1 NONUNIQUE APPS_TS_TX_IDX PARENT_TAX_LINE_ID
INL_TAX_LINES_N2 NONUNIQUE APPS_TS_TX_IDX SHIP_HEADER_ID
INL_TAX_LINES_N3 NONUNIQUE APPS_TS_TX_IDX MATCH_ID
INL_TAX_LINES_N4 NONUNIQUE APPS_TS_TX_IDX MATCH_AMOUNT_ID
INL_TAX_LINES_N5 NONUNIQUE APPS_TS_TX_IDX ADJUSTMENT_NUM
SHIP_HEADER_ID
SOURCE_PARENT_TABLE_ID
SOURCE_PARENT_TABLE_NAME
Columns
Name Datatype Length Mandatory Comments
TAX_LINE_ID NUMBER
Y Tax Line Identifier
TAX_LINE_NUM NUMBER
Y Tax Line Number
TAX_CODE VARCHAR2 (30) Y Tax Code
SHIP_HEADER_ID NUMBER

Shipment Identifier
PARENT_TAX_LINE_ID NUMBER

Parent Tax Line Identifier
ADJUSTMENT_NUM NUMBER
Y Adjustment Number
MATCH_ID NUMBER

Match Identifier
MATCH_AMOUNT_ID NUMBER

Match Amount Identifier
SOURCE_PARENT_TABLE_NAME VARCHAR2 (30) Y Name of the table the tax is captured from: INL_TAX_LINES, ZX_LINES, AP_INVOICE_DISTRIBUTIONS
SOURCE_PARENT_TABLE_ID NUMBER
Y Identifier of the table line the tax is captured from: TAX_LINE_ID, INVOICE_DISTRIBUTION_ID
TAX_AMT NUMBER
Y Tax Amount
NREC_TAX_AMT NUMBER

Non Recoverable Tax Amount
CURRENCY_CODE VARCHAR2 (15)
Currency Code
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
Currency Conversion Type
CURRENCY_CONVERSION_DATE DATE

Currency Conversion Date
CURRENCY_CONVERSION_RATE NUMBER

Currency Conversion Rate
TAX_AMT_INCLUDED_FLAG VARCHAR2 (1)
"Y" or "N" flag indicating whether the tax is inclusive
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y 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).

[top of page]

INL.INL_TAX_LINES does not reference any database object

INL.INL_TAX_LINES is referenced by following:

INL
VIEW - INL_TAX_LINES#

[top of page]

View: INL_ADJ_ASSOCIATIONS_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
ASSOCIATION_ID NUMBER
Y Association Identifier
SHIP_HEADER_ID NUMBER
Y Shipment Header Identifier
FROM_PARENT_TABLE_NAME VARCHAR2 (30) Y Name of the table the amount comes from: INL_SHIP_LINES, INL_CHARGE_LINES, INL_TAX_LINES
FROM_PARENT_TABLE_ID NUMBER

Identifier of the table line the amount comes from: SHIP_LINE_ID, CHARGE_LINE_ID, TAX_LINE_ID
TO_PARENT_TABLE_NAME VARCHAR2 (30) Y Name of the table the amount goes to: INL_SHIP_HEADERS, INL_SHIP_LINE_GROUPS, INL_SHIP_LINES
TO_PARENT_TABLE_ID NUMBER

Identifier of the table line the amount goes to: SHIP_HEADER_ID, SHIP_LINE_GROUP_ID, SHIP_LINE_ID
ALLOCATION_BASIS VARCHAR2 (30) Y Criteria through which an associated amount will be distributed into two or more components of a shipment
ALLOCATION_UOM_CODE VARCHAR2 (3)
Unit of measure through which the associated amount will be distributed into two or more components of a shipment
ADJUSTMENT_TYPE_FLAG VARCHAR2 (1)
"A" or "R" flag to indicate whether the association will be added ("A") or removed ("R"), when the completed shipment is submitted

[top of page]

APPS.INL_ADJ_ASSOCIATIONS_V references the following:

APPS
SYNONYM - INL_ASSOCIATIONS
SYNONYM - INL_CHARGE_LINES
SYNONYM - INL_SHIP_LINES_ALL
SYNONYM - INL_TAX_LINES

APPS.INL_ADJ_ASSOCIATIONS_V is not referenced by any database object

[top of page]

View: INL_ADJ_CHARGE_LINES_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
CHARGE_LINE_ID NUMBER
Y Charge Line Identifier
CHARGE_LINE_NUM NUMBER
Y Charge Line Number
CHARGE_LINE_TYPE_ID NUMBER
Y Charge Line Type Identifier
LANDED_COST_FLAG VARCHAR2 (1) Y "Y" or "N" flag indicating whether the amount should be considered in the landed cost
UPDATE_ALLOWED VARCHAR2 (1)
"Y" or "N" flag indicating whether the charge can be updated
SOURCE_CODE VARCHAR2 (25)
Source Application Code the charge is being created from
PARENT_CHARGE_LINE_ID NUMBER

Parent Charge Line Identifier
ADJUSTMENT_NUM NUMBER
Y Adjustment Number
MATCH_ID NUMBER

Match Identifier
MATCH_AMOUNT_ID NUMBER

Match Amount Identifier
CHARGE_AMT NUMBER
Y Charge Ammount
CURRENCY_CODE VARCHAR2 (15)
Currency Code
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
Currency Conversion Type
CURRENCY_CONVERSION_DATE DATE

Currency Conversion Date
CURRENCY_CONVERSION_RATE NUMBER

Currency Conversion Rate
PARTY_ID NUMBER

Party Identifier
PARTY_SITE_ID NUMBER

Party Site Identifier
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
TAX_ALREADY_CALCULATED_FLAG VARCHAR2 (1)
"Y" or "N" flag indicating whether the taxes have already been calculated
SHIP_FROM_PARTY_ID NUMBER

Ship From Party Identifier
SHIP_FROM_PARTY_SITE_ID NUMBER

Ship From Party Site Identifier
SHIP_TO_ORGANIZATION_ID NUMBER

Ship To Organization Identifier
SHIP_TO_LOCATION_ID NUMBER

Ship To Location Identifier
BILL_FROM_PARTY_ID NUMBER

Bill From Party Identifier
BILL_FROM_PARTY_SITE_ID NUMBER

Bill From Party Site Identifier
BILL_TO_ORGANIZATION_ID NUMBER

Bill To Organization Identifier
BILL_TO_LOCATION_ID NUMBER

Bill To Location Identifier
POA_PARTY_ID NUMBER

Point of Order Acceptance Party Identifier
POA_PARTY_SITE_ID NUMBER

Point of Order Acceptance Party Site Identifier
POO_ORGANIZATION_ID NUMBER

Point of Order Origin Organization Identifier
POO_LOCATION_ID NUMBER

Point of Order Origin Location Identifier
NEW_CHARGE_AMT NUMBER

New Charge Amount
NEW_CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
New Currency Conversion Type
NEW_CURRENCY_CONVERSION_DATE DATE

New Currency Conversion Date
NEW_CURRENCY_CONVERSION_RATE NUMBER

New Currency Conversion Rate
ADJUSTMENT_TYPE_FLAG VARCHAR2 (1)
"A", "R" or "Z" flag to indicate whether the charge line will be added ("A"), removed ("R") or zeroed out ("Z") when the completed shipment is submitted

[top of page]

APPS.INL_ADJ_CHARGE_LINES_V references the following:

APPS
SYNONYM - INL_CHARGE_LINES
APPS.INL_ADJ_CHARGE_LINES_V is referenced by following:

APPS
VIEW - INL_CHARGE_OVERALL_V

[top of page]

View: INL_ADJ_SHIP_LINES_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
SHIP_HEADER_ID NUMBER
Y Shipment Identifier
SHIP_LINE_GROUP_ID NUMBER
Y Shipment Line Group Identifier
SHIP_LINE_ID NUMBER
Y Shipment Line Identifier
SHIP_LINE_NUM NUMBER
Y Shipment Line Number
SHIP_LINE_TYPE_ID NUMBER
Y Shipment Line Type Identifier
SHIP_LINE_SRC_TYPE_CODE VARCHAR2 (30)
Shipment Line Source Type Code
SHIP_LINE_SOURCE_ID NUMBER

Shipment Line Source Identifier
PARENT_SHIP_LINE_ID NUMBER

Parent Shipment Line Identifier
ADJUSTMENT_NUM NUMBER
Y Adjustment Number
MATCH_ID NUMBER

Match Identifier
CURRENCY_CODE VARCHAR2 (15) Y 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
FC_PRIMARY_UNIT_PRICE NUMBER

Functional Primary Unit Price
SECONDARY_QTY NUMBER

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

Secondary Unit Price
NRQ_ZERO_EXCEPTION_FLAG VARCHAR2 (1)
NRQ Zero Exception Flag
LANDED_COST_FLAG VARCHAR2 (1) Y Landed Cost Flag
ALLOCATION_ENABLED_FLAG VARCHAR2 (1) Y Allocation Enabled Flag
TRX_BUSINESS_CATEGORY VARCHAR2 (240)
Transaction Business Category
INTENDED_USE VARCHAR2 (30)
Intended Use
PRODUCT_FISCAL_CLASS VARCHAR2 (240)
Product Fiscal Classification
PRODUCT_CATEGORY VARCHAR2 (240)
Product Category
PRODUCT_TYPE VARCHAR2 (240)
Product Type
USER_DEF_FISCAL_CLASS VARCHAR2 (240)
User Definition Fical Classification
TAX_CLASSIFICATION_CODE VARCHAR2 (30)
Transaction Classification Code
ASSESSABLE_VALUE NUMBER

Assessable Value
TAX_ALREADY_CALCULATED_FLAG VARCHAR2 (1)
Tax Already Calculated Flag
SHIP_FROM_PARTY_ID NUMBER

Ship From Party Identifier
SHIP_FROM_PARTY_SITE_ID NUMBER

Ship From Party Site Identifier
SHIP_TO_ORGANIZATION_ID NUMBER

Ship To Organization Identifier
SHIP_TO_LOCATION_ID NUMBER

Ship To Location Identifier
BILL_FROM_PARTY_ID NUMBER

Bill From Party Identifier
BILL_FROM_PARTY_SITE_ID NUMBER

Bill From Party Site Identifier
BILL_TO_ORGANIZATION_ID NUMBER

Bill To Organzination Identifier
BILL_TO_LOCATION_ID NUMBER

POA_PARTY_ID NUMBER

Poa Party Identifier
POA_PARTY_SITE_ID NUMBER

Poa Party Site Identifier
POO_ORGANIZATION_ID NUMBER

Poo Organization Identifier
POO_LOCATION_ID NUMBER

Poo Location Identifier
ORG_ID NUMBER
Y Operating Unit Identifier
SHIP_LINE_INT_ID NUMBER

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

Source line identifier of the interface row
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)
Attribute Category
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)
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
NEW_TXN_UNIT_PRICE NUMBER

New Transaction Unit Price
NEW_CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
New Currency Conversion Type
NEW_CURRENCY_CONVERSION_DATE DATE

New Currency Conversion Date
NEW_CURRENCY_CONVERSION_RATE NUMBER

New Currency Conversion Rate

[top of page]

APPS.INL_ADJ_SHIP_LINES_V references the following:

APPS
SYNONYM - INL_SHIP_LINES_ALL
APPS.INL_ADJ_SHIP_LINES_V is referenced by following:

APPS
VIEW - INL_SHIP_OVERALL_V

[top of page]

View: INL_ADJ_TAX_LINES_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
TAX_LINE_ID NUMBER
Y Tax Line Identifier
TAX_LINE_NUM NUMBER
Y Tax Line Number
TAX_CODE VARCHAR2 (30) Y Tax Code
SHIP_HEADER_ID NUMBER

Shipment Identifier
PARENT_TAX_LINE_ID NUMBER

Parent Tax Line Identifier
ADJUSTMENT_NUM NUMBER
Y Adjustment Number
MATCH_ID NUMBER

Match Identifier
MATCH_AMOUNT_ID NUMBER

Match Amount Identifier
SOURCE_PARENT_TABLE_NAME VARCHAR2 (30) Y Name of the table the tax is captured from: INL_TAX_LINES, ZX_LINES, AP_INVOICE_DISTRIBUTIONS.
SOURCE_PARENT_TABLE_ID NUMBER
Y Identifier of the table line the tax is captured from: TAX_LINE_ID, INVOICE_DISTRIBUTION_ID
TAX_AMT NUMBER
Y Tax Amount
NREC_TAX_AMT NUMBER

Non Recoverable Tax Amount
CURRENCY_CODE VARCHAR2 (15)
Currency Code
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
Currency Conversion Type
CURRENCY_CONVERSION_DATE DATE

Currency Conversion Date
CURRENCY_CONVERSION_RATE NUMBER

Currency Conversion Rate
TAX_AMT_INCLUDED_FLAG VARCHAR2 (1)
"Y" or "N" flag indicating whether the tax is inclusive
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y 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).

[top of page]

APPS.INL_ADJ_TAX_LINES_V references the following:

APPS
SYNONYM - INL_TAX_LINES

APPS.INL_ADJ_TAX_LINES_V is not referenced by any database object

[top of page]

View: INL_ALLOCATIONS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ALLOCATION_ID NUMBER
Y Allocation Identifier
SHIP_HEADER_ID NUMBER
Y Shipment Identifier
ASSOCIATION_ID NUMBER

Association Identifier
PARENT_ALLOCATION_ID NUMBER

Parent Allocation Identifier
FROM_PARENT_TABLE_NAME VARCHAR2 (30) Y Name of the table the amount comes from: INL_SHIP_LINES, INL_CHARGE_LINES, INL_TAX_LINES
FROM_PARENT_TABLE_ID NUMBER
Y Identifier of the table line the amount comes from: SHIP_LINE_ID, CHARGE_LINE_ID, TAX_LINE_ID
TO_PARENT_TABLE_NAME VARCHAR2 (30) Y Name of the table the amount goes to: INL_SHIP_HEADERS, INL_SHIP_LINE_GROUPS, INL_SHIP_LINES
TO_PARENT_TABLE_ID NUMBER
Y Identifier of the table line the amount goes to: SHIP_HEADER_ID, SHIP_LINE_GROUP_ID, SHIP_LINE_ID
SHIP_LINE_ID NUMBER

Shipment Line Identifier
ADJUSTMENT_NUM NUMBER
Y Adjustment Number
ESTIMATED_AMT NUMBER

Estimated Amount
ALLOCATION_AMT NUMBER
Y Allocation Amount
LANDED_COST_FLAG VARCHAR2 (1) Y "Y" or "N" flag indicating whether the amount should be considered in the landed cost
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y 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).

[top of page]

APPS.INL_ALLOCATIONS_V references the following:

APPS
SYNONYM - INL_ALLOCATIONS
SYNONYM - INL_SHIP_LINES_ALL

APPS.INL_ALLOCATIONS_V is not referenced by any database object

[top of page]

View: INL_ALLOCATION_BASIS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

This view shows Allocation Basis information in a given language.

Columns
Name Datatype Length Mandatory Comments
ALLOCATION_BASIS_ID NUMBER

Allocation Basis Identifier
ALLOCATION_BASIS_CODE VARCHAR2 (30) Y Allocation Basis Code
ALLOCATION_BASIS_NAME VARCHAR2 (80) Y Allocation Basis Name
UOM_CLASS VARCHAR2 (10)
Class of Unif of Measure
BASE_UOM_CODE VARCHAR2 (3)
Base Unit of Measure of the Class

[top of page]

APPS.INL_ALLOCATION_BASIS_VL references the following:

APPS
VIEW - FND_LOOKUP_VALUES_VL
PACKAGE - FND_PROFILE
- MTL_UNITS_OF_MEASURE

APPS.INL_ALLOCATION_BASIS_VL is not referenced by any database object

[top of page]

View: INL_ALLOCATION_FLOW_V

Comments
Columns
Name Datatype Length Mandatory Comments
SHIP_HEADER_ID NUMBER

ADJUSTMENT_NUM NUMBER

ASSOCIATION_ID NUMBER

PARENT_TABLE_NAME VARCHAR2 (30)
PARENT_TABLE_ID NUMBER

ALLOCATION_AMT NUMBER

ASSOC_FROM_PARENT_TABLE_NAME VARCHAR2 (30)
ASSOC_FROM_PARENT_TABLE_ID NUMBER

[top of page]

APPS.INL_ALLOCATION_FLOW_V references the following:

APPS
SYNONYM - INL_ALLOCATIONS
SYNONYM - INL_ASSOCIATIONS

APPS.INL_ALLOCATION_FLOW_V is not referenced by any database object

[top of page]

View: INL_ALLOCATION_SUMMARY_V

Comments
Columns
Name Datatype Length Mandatory Comments
SHIP_HEADER_ID NUMBER
Y
ADJUSTMENT_NUM NUMBER
Y
ORGANIZATION_ID NUMBER
Y
INVENTORY_ITEM_ID NUMBER

PRIMARY_QTY NUMBER

PRIMARY_UOM_CODE VARCHAR2 (3)
SHIP_LINE_GROUP_ID NUMBER

SHIP_LINE_ID NUMBER

SHIP_LINE_NUM NUMBER

ASSOCIATION_ID NUMBER

ASSOC_FROM_PARENT_TABLE_NAME VARCHAR2 (30)
ASSOC_FROM_PARENT_TABLE_ID NUMBER

CHARGE_LINE_ID NUMBER

TAX_LINE_ID NUMBER

ALLOCATION_ID NUMBER
Y
ALLOCATION_AMT NUMBER
Y
LANDED_COST_FLAG VARCHAR2 (1) Y

[top of page]

APPS.INL_ALLOCATION_SUMMARY_V references the following:

APPS
SYNONYM - INL_ALLOCATIONS
SYNONYM - INL_ASSOCIATIONS
SYNONYM - INL_SHIP_HEADERS_ALL
SYNONYM - INL_SHIP_LINES_ALL

APPS.INL_ALLOCATION_SUMMARY_V is not referenced by any database object

[top of page]

View: INL_ATTRIBUTES_VL

Comments
Columns
Name Datatype Length Mandatory Comments
ATTRIBUTE_CODE VARCHAR2 (30) Y Attribute Code
ATTRIBUTE_NAME VARCHAR2 (80) Y Attribute Name
DESCRIPTION VARCHAR2 (240)
Description
ENTITY_CODE VARCHAR2 (30) Y Entity Code
DATATYPE_CODE VARCHAR2 (1) Y Datatype Code
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y 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).

[top of page]

APPS.INL_ATTRIBUTES_VL references the following:

APPS
SYNONYM - INL_ATTRIBUTES_B
SYNONYM - INL_ATTRIBUTES_TL

APPS.INL_ATTRIBUTES_VL is not referenced by any database object

[top of page]

View: INL_CHARGE_LINE_TYPES_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

This view shows Charge Line Type information in a given language.

Columns
Name Datatype Length Mandatory Comments
CHARGE_LINE_TYPE_ID NUMBER
Y Charge Line Type Identifier
CHARGE_LINE_TYPE_CODE VARCHAR2 (30) Y Charge Line Type Code
CHARGE_LINE_TYPE_NAME VARCHAR2 (80) Y Charge Line Type Name
DFLT_LANDED_COST_FLAG CHAR (1)
"Y" or "N" flag indicating whether the amounts of the line should be considered in the landed cost
AP_LINE_TYPE_CODE CHAR (13)
Payables Invoice Line Type lookup code
ALLOCATION_BASIS VARCHAR2 (30)
Criteria through which an associated amount will be distributed into two or more components of a shipment
ACTIVE_FROM_DATE DATE

Active From Date
ACTIVE_TO_DATE DATE

Active To Date
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.

[top of page]

APPS.INL_CHARGE_LINE_TYPES_VL references the following:

- PON_COST_FACTORS_VL

APPS.INL_CHARGE_LINE_TYPES_VL is not referenced by any database object

[top of page]

View: INL_CHARGE_OVERALL_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
SHIP_HEADER_ID NUMBER
Y Shipment Identifier
ORGANIZATION_ID NUMBER
Y Inventory Organization Identifier
LOCATION_ID NUMBER

Location Identifier
ORG_ID NUMBER
Y Operating Unit Identifier
SHIP_TYPE_ID NUMBER
Y Shipment Type Identifier
SHIP_NUM VARCHAR2 (25) Y Shipment Number
SHIP_DATE DATE
Y Shipment Date
SHIP_STATUS_CODE VARCHAR2 (30) Y 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
LINE_GROUP_PARTY_ID NUMBER

Line Group Party Identifier
LINE_GROUP_PARTY_SITE_ID NUMBER

Line Group Party Site Identifier
CHARGE_LINE_ID NUMBER
Y Charge Line Identifier
CHARGE_LINE_NUM NUMBER
Y Charge Line Number
CHARGE_LINE_TYPE_ID NUMBER
Y Charge Line Type Identifier
LANDED_COST_FLAG VARCHAR2 (1) Y "Y" or "N" flag indicating whether the amount should be considered in the landed cost
PARENT_CHARGE_LINE_ID NUMBER

Parent Charge Line Identifier
ADJUSTMENT_NUM NUMBER
Y Adjustment Number
MATCH_ID NUMBER

Match Identifier
CHARGE_AMT NUMBER
Y Charge Ammount
CURRENCY_CODE VARCHAR2 (15)
Currency Code
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
Currency Conversion Type
CURRENCY_CONVERSION_DATE DATE

Currency Conversion Date
CURRENCY_CONVERSION_RATE NUMBER

Currency Conversion Rate
PARTY_ID NUMBER

Party Identifier
GROUP_PARTY_NAME VARCHAR2 (360)
Group Party Name
PARTY_SITE_ID NUMBER

Party Site Identifier
GROUP_PARTY_SITE_NAME VARCHAR2 (240)
Group Party Site Name
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
TAX_ALREADY_CALCULATED_FLAG VARCHAR2 (1)
"Y" or "N" flag indicating whether the taxes have already been calculated
SHIP_FROM_PARTY_ID NUMBER

Ship From Party Identifier
SHIP_FROM_PARTY_SITE_ID NUMBER

Ship From Party Site Identifier
SHIP_TO_ORGANIZATION_ID NUMBER

Ship To Organization Identifier
SHIP_TO_LOCATION_ID NUMBER

Ship To Location Identifier
BILL_FROM_PARTY_ID NUMBER

Bill From Party Identifier
BILL_FROM_PARTY_SITE_ID NUMBER

Bill From Party Site Identifier
BILL_TO_ORGANIZATION_ID NUMBER

Bill To Organization Identifier
BILL_TO_LOCATION_ID NUMBER

Bill To Location Identifier
POA_PARTY_ID NUMBER

Point of Order Acceptance Party Identifier
POA_PARTY_SITE_ID NUMBER

Point of Order Acceptance Party Site Identifier
POO_ORGANIZATION_ID NUMBER

Point of Order Origin Organization Identifier
POO_LOCATION_ID NUMBER

Point of Order Origin Location Identifier

[top of page]

APPS.INL_CHARGE_OVERALL_V references the following:

APPS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_PARTY_SITES
VIEW - INL_ADJ_CHARGE_LINES_V
SYNONYM - INL_ASSOCIATIONS
SYNONYM - INL_SHIP_HEADERS
SYNONYM - INL_SHIP_LINE_GROUPS

APPS.INL_CHARGE_OVERALL_V is not referenced by any database object

[top of page]

View: INL_CORR_MATCHES_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
MATCH_ID NUMBER
Y Match Identifier
ADJ_GROUP_DATE DATE

Group date for adjustment creation
MATCH_TYPE_CODE VARCHAR2 (30) Y Match Type Code
SHIP_HEADER_ID NUMBER

Shipment Identifier
FROM_PARENT_TABLE_NAME VARCHAR2 (30)
Identifier of the table line the match comes from.
FROM_PARENT_TABLE_ID NUMBER

Identifier of the table line the match comes from
TO_PARENT_TABLE_NAME VARCHAR2 (30)
Name of the table the match goes to: INL_SHIP_LINES
TO_PARENT_TABLE_ID NUMBER

Identifier of the table line the match goes to: SHIP_LINE_ID
MATCHED_QTY NUMBER

Matched Quantity
MATCHED_UOM_CODE VARCHAR2 (3)
Matched Unit of Measure
MATCHED_AMT NUMBER

Matched Amount
CORRECTION_MATCH_ID VARCHAR2 (40)
Correction Match Identifier
MATCHED_CURR_CODE VARCHAR2 (15)
Matched Currency Code
MATCHED_CURR_CONVERSION_TYPE VARCHAR2 (30)
Matched Currency Conversion Type
MATCHED_CURR_CONVERSION_DATE DATE

Matched Currency Conversion Date
MATCHED_CURR_CONVERSION_RATE NUMBER

Matched Currency Conversion Rate
ADJ_ALREADY_GENERATED_FLAG VARCHAR2 (1)
"Y" or "N" flag indicating whether the match has already generated adjustments
REPLACE_ESTIM_QTY_FLAG VARCHAR2 (1) Y "Y" or "N" flag indicating whether the quantities should be also adjusted beside the amounts.
EXISTING_MATCH_INFO_FLAG VARCHAR2 (1)
"Y" or "N" flag indicating whether the match corresponds to data already matched (match update)
CHARGE_LINE_TYPE_ID NUMBER

Charge Line Type Identifier
PARTY_ID NUMBER

Party Identifier
PARTY_SITE_ID NUMBER

Party Site Identifier
TAX_CODE VARCHAR2 (30)
Tax Code
NREC_TAX_AMT NUMBER

Non Recoverable Tax Amount
TAX_AMT_INCLUDED_FLAG VARCHAR2 (1)
"Y" or "N" flag indicating whether the tax is included to the unit price.
MATCH_AMOUNT_ID NUMBER

Match Amount Identifier
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).
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y 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).

[top of page]

APPS.INL_CORR_MATCHES_V references the following:

APPS
PACKAGE - INL_LANDEDCOST_PVT
SYNONYM - INL_MATCHES

APPS.INL_CORR_MATCHES_V is not referenced by any database object

[top of page]

View: INL_CORR_MATCH_AMOUNTS_V

Comments
Columns
Name Datatype Length Mandatory Comments
MATCH_AMOUNT_ID NUMBER
Y
MATCHED_AMT NUMBER

MATCHED_CURR_CODE VARCHAR2 (15) Y
MATCHED_CURR_CONVERSION_TYPE VARCHAR2 (30)
MATCHED_CURR_CONVERSION_DATE DATE

MATCHED_CURR_CONVERSION_RATE NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

PROGRAM_APPLICATION_ID NUMBER

REQUEST_ID NUMBER

CREATED_BY NUMBER
Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER
Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER

[top of page]

APPS.INL_CORR_MATCH_AMOUNTS_V references the following:

APPS
PACKAGE - INL_LANDEDCOST_PVT
SYNONYM - INL_MATCH_AMOUNTS
- INL_CORR_MATCHES_V

APPS.INL_CORR_MATCH_AMOUNTS_V is not referenced by any database object

[top of page]

View: INL_DET_LANDED_COSTS_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
SHIP_HEADER_ID NUMBER
Y Shipment Header Identifier
ADJUSTMENT_NUM NUMBER
Y Adjustment Number
SHIP_LINE_GROUP_ID NUMBER
Y Line Group Identifier
SHIP_LINE_ID NUMBER
Y Shipment Line Identifier
PARENT_SHIP_LINE_ID NUMBER

Parent Shipment Line Identifier
SHIP_LINE_NUM NUMBER
Y Shipment Line Number
ORGANIZATION_ID NUMBER
Y Inventory Organization Identifier
INVENTORY_ITEM_ID NUMBER

Inventory Item Identifier
INV_ITEM VARCHAR2 (40)
Inventory Item Concatenated Segments
PRIMARY_QTY NUMBER

Primary Quantity
UNIT_OF_MEASURE VARCHAR2 (25) Y Unit of Measure
COMPONENT_TYPE VARCHAR2 (10)
Component Type
COMPONENT_CODE VARCHAR2 (40)
Component Code
COMPONENT_NAME VARCHAR2 (80)
Component Name
CHARGE_LINE_TYPE_ID NUMBER

Charge Line Type Identifier
ALLOCATED_AMT NUMBER

Allocated Amount
ALLOCATION_PERCENT NUMBER

Allocation Percent
ESTIMATED_ALLOCATED_AMT NUMBER

Estimated Allocated Amount
ESTIMATED_ALLOCATION_PERCENT NUMBER

Estimated Percentual of Allocation

[top of page]

APPS.INL_DET_LANDED_COSTS_V references the following:

APPS
SYNONYM - INL_ALLOCATIONS
SYNONYM - INL_ASSOCIATIONS
SYNONYM - INL_CHARGE_LINES
SYNONYM - INL_SHIP_HEADERS_ALL
SYNONYM - INL_SHIP_LINES_ALL
SYNONYM - INL_TAX_LINES
- MTL_SYSTEM_ITEMS_KFV
- PON_PRICE_ELEMENT_TYPES_VL
- MTL_UNITS_OF_MEASURE

APPS.INL_DET_LANDED_COSTS_V is not referenced by any database object

[top of page]

View: INL_EBTAX_LINES_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
SOURCE VARCHAR2 (9)
Source
SHIP_LINE_ID NUMBER

Shipment Line Identifier
SHIP_LINE_GROUP_ID NUMBER

Line Group Identifier
SHIP_LINE_NUM NUMBER

Shipment Line Number
SHIP_LINE_TYPE_ID NUMBER

Shipment Line Type Identifier
SRC_TYPE_CODE VARCHAR2 (30)
Source Type Code
SRC_ID NUMBER

Source Identifier
SHIP_HEADER_ID NUMBER

Shipment Identifier
UNIT_PRICE NUMBER

Unit Price
INVENTORY_ITEM_ID NUMBER

Inventory Item Identifier
UOM_CODE VARCHAR2 (3)
Unit of Measure
PARTY_ID NUMBER

Party Identifier
PARTY_SITE_ID NUMBER

Party Site Identifier
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
LINE_AMT NUMBER

Line Amount
LINE_QTY NUMBER

Line Quantity
TAX_ALREADY_CALCULATED_FLAG VARCHAR2 (1)
"Y" or "N" flag indicating whether the taxes have already been calculated
SHIP_FROM_PARTY_ID NUMBER

Ship From Party Identifier
SHIP_FROM_PARTY_SITE_ID NUMBER

Ship From Party Site Identifier
SHIP_TO_ORGANIZATION_ID NUMBER

Ship To Organization Identifier
SHIP_TO_LOCATION_ID NUMBER

Ship To Location Identifier
BILL_FROM_PARTY_ID NUMBER

Bill From Party Identifier
BILL_FROM_PARTY_SITE_ID NUMBER

Bill From Party Site Identifier
BILL_TO_ORGANIZATION_ID NUMBER

Bill To Organization Identifier
BILL_TO_LOCATION_ID NUMBER

Bill To Location Identifier
POA_PARTY_ID NUMBER

Point of Order Acceptance Party Identifier
POA_PARTY_SITE_ID NUMBER

Point of Order Acceptance Party Site Identifier
POO_ORGANIZATION_ID NUMBER

Point of Order Origin Organization Identifier
POO_LOCATION_ID NUMBER

Point of Order Origin Location Identifier
CURRENCY_CODE VARCHAR2 (15)
Currency Code
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
Currency Conversion Type
CURRENCY_CONVERSION_DATE DATE

Currency Conversion Date
CURRENCY_CONVERSION_RATE NUMBER

Currency Conversion Rate
ADJUSTMENT_NUM NUMBER

Adjustment Number

[top of page]

APPS.INL_EBTAX_LINES_V references the following:

- INL_ADJ_CHARGE_LINES_V
- INL_ADJ_SHIP_LINES_V

APPS.INL_EBTAX_LINES_V is not referenced by any database object

[top of page]

View: INL_ENTER_RECEIPTS_PO_V

Comments
Columns
Name Datatype Length Mandatory Comments
LINE_CHKBOX CHAR (1)
SOURCE_TYPE_CODE CHAR (6)
RECEIPT_SOURCE_CODE CHAR (6)
ORDER_TYPE_CODE CHAR (2)
ORDER_TYPE VARCHAR2 (25) Y
PO_HEADER_ID NUMBER
Y
PO_NUMBER VARCHAR2 (20) Y
PO_LINE_ID NUMBER
Y
PO_LINE_NUMBER NUMBER
Y
PO_LINE_LOCATION_ID NUMBER
Y
PO_SHIPMENT_NUMBER NUMBER

PO_RELEASE_ID NUMBER

PO_RELEASE_NUMBER NUMBER

REQ_HEADER_ID NUMBER

REQ_NUMBER VARCHAR2 (0)
REQ_LINE_ID NUMBER

REQ_LINE NUMBER

REQ_DISTRIBUTION_ID NUMBER

RCV_SHIPMENT_HEADER_ID NUMBER

RCV_SHIPMENT_NUMBER VARCHAR2 (0)
RCV_SHIPMENT_LINE_ID NUMBER

RCV_LINE_NUMBER NUMBER

FROM_ORGANIZATION_ID NUMBER
Y
TO_ORGANIZATION_ID NUMBER

VENDOR_ID NUMBER

SOURCE VARCHAR2 (240)
VENDOR_SITE_ID NUMBER

OUTSIDE_OPERATION_FLAG VARCHAR2 (1)
ITEM_ID NUMBER

PRIMARY_UOM VARCHAR2 (25)
PRIMARY_UOM_CLASS VARCHAR2 (10)
ITEM_ALLOWED_UNITS_LOOKUP_CODE NUMBER

ITEM_LOCATOR_CONTROL NUMBER

RESTRICT_LOCATORS_CODE VARCHAR2 (1)
RESTRICT_SUBINVENTORIES_CODE VARCHAR2 (1)
SHELF_LIFE_CODE NUMBER

SHELF_LIFE_DAYS NUMBER

SERIAL_NUMBER_CONTROL_CODE NUMBER

LOT_CONTROL_CODE NUMBER

ITEM_REV_CONTROL_FLAG_TO VARCHAR2 (1)
ITEM_REV_CONTROL_FLAG_FROM VARCHAR2 (0)
ITEM_NUMBER VARCHAR2 (0)
ITEM_REVISION VARCHAR2 (3)
ITEM_DESCRIPTION VARCHAR2 (240)
ITEM_CATEGORY_ID NUMBER

HAZARD_CLASS VARCHAR2 (40)
UN_NUMBER VARCHAR2 (25)
VENDOR_ITEM_NUMBER VARCHAR2 (25)
SHIP_TO_LOCATION_ID NUMBER

SHIP_TO_LOCATION VARCHAR2 (60)
PACKING_SLIP VARCHAR2 (0)
ROUTING_ID NUMBER

ROUTING_NAME VARCHAR2 (80)
NEED_BY_DATE DATE

EXPECTED_RECEIPT_DATE DATE

ORDERED_QTY NUMBER

ORDERED_UOM VARCHAR2 (25)
USSGL_TRANSACTION_CODE VARCHAR2 (0)
GOVERNMENT_CONTEXT VARCHAR2 (30)
INSPECTION_REQUIRED_FLAG VARCHAR2 (1)
RECEIPT_REQUIRED_FLAG VARCHAR2 (1)
ENFORCE_SHIP_TO_LOCATION_CODE VARCHAR2 (25)
UNIT_PRICE NUMBER

CURRENCY_CODE VARCHAR2 (15)
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
CURRENCY_CONVERSION_DATE DATE

CURRENCY_CONVERSION_RATE NUMBER

NOTE_TO_RECEIVER VARCHAR2 (480)
DESTINATION_TYPE_CODE VARCHAR2 (0)
DELIVER_TO_PERSON_ID NUMBER

DELIVER_TO_LOCATION_ID NUMBER

DESTINATION_SUBINVENTORY VARCHAR2 (0)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
CLOSED_CODE VARCHAR2 (30)
ASN_TYPE VARCHAR2 (0)
BILL_OF_LADING VARCHAR2 (0)
SHIPPED_DATE DATE

FREIGHT_CARRIER_CODE VARCHAR2 (0)
WAYBILL_AIRBILL_NUM VARCHAR2 (0)
FREIGHT_BILL_NUM VARCHAR2 (0)
VENDOR_LOT_NUM VARCHAR2 (0)
CONTAINER_NUM VARCHAR2 (0)
TRUCK_NUM VARCHAR2 (0)
BAR_CODE_LABEL VARCHAR2 (0)
RATE_TYPE_DISPLAY VARCHAR2 (30)
MATCH_OPTION VARCHAR2 (25)
COUNTRY_OF_ORIGIN_CODE VARCHAR2 (2)
OE_ORDER_HEADER_ID NUMBER

OE_ORDER_NUM NUMBER

OE_ORDER_LINE_ID NUMBER

OE_ORDER_LINE_NUM NUMBER

CUSTOMER_ID NUMBER

CUSTOMER_SITE_ID NUMBER

CUSTOMER_ITEM_NUM VARCHAR2 (0)
PLL_NOTE_TO_RECEIVER VARCHAR2 (480)
SECONDARY_ORDERED_QTY NUMBER

SECONDARY_ORDERED_UOM VARCHAR2 (25)
QC_GRADE VARCHAR2 (150)
LPN_ID NUMBER

SECONDARY_DEFAULT_IND VARCHAR2 (30)
ORG_ID NUMBER

OE_ORDER_SHIP_NUM NUMBER

LCM_SHIPMENT_LINE_ID NUMBER

UNIT_LANDED_COST NUMBER

LCM_SHIPMENT_FLAG VARCHAR2 (1)

[top of page]

APPS.INL_ENTER_RECEIPTS_PO_V references the following:

APPS
SYNONYM - GL_DAILY_CONVERSION_TYPES
SYNONYM - HR_LOCATIONS_ALL_TL
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - PO_HAZARD_CLASSES_TL
SYNONYM - PO_HEADERS_ALL
SYNONYM - PO_LINES_ALL
SYNONYM - PO_LINE_LOCATIONS
SYNONYM - PO_LINE_TYPES_B
SYNONYM - PO_RELEASES_ALL
SYNONYM - PO_UN_NUMBERS_TL
VIEW - PO_VENDORS
- RCV_ROUTING_HEADERS
- MTL_UNITS_OF_MEASURE

APPS.INL_ENTER_RECEIPTS_PO_V is not referenced by any database object

[top of page]

View: INL_ENTER_RECEIPTS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
LINE_CHKBOX CHAR (1)
"Y" or "N" indicating whether Shipment Line is checked
SOURCE_TYPE_CODE CHAR (6)
Source Type Code
RECEIPT_SOURCE_CODE CHAR (6)
Receipt Source Code
ORDER_TYPE_CODE CHAR (2)
Order Type Code
ORDER_TYPE VARCHAR2 (25) Y Order Type
PO_HEADER_ID NUMBER
Y PO Header Identifier
PO_NUMBER VARCHAR2 (20) Y PO Number
PO_LINE_ID NUMBER
Y PO Line Identifier
PO_LINE_NUMBER NUMBER
Y PO Line Number
PO_LINE_LOCATION_ID NUMBER
Y PO Line Location Identifier
PO_SHIPMENT_NUMBER NUMBER

PO Shipment Number
PO_RELEASE_ID NUMBER

PO Release Identifier
PO_RELEASE_NUMBER NUMBER

PO Release Number
REQ_HEADER_ID NUMBER

Requisition Header Identifier
REQ_NUMBER VARCHAR2 (0)
Requisition Number
REQ_LINE_ID NUMBER

Requisition Line Identifier
REQ_LINE NUMBER

Requisition Line
REQ_DISTRIBUTION_ID NUMBER

Requisition Distribution Identifier
RCV_SHIPMENT_HEADER_ID NUMBER

RCV Shipment Header Identifier
RCV_SHIPMENT_NUMBER VARCHAR2 (0)
RCV_SHIPMENT_LINE_ID NUMBER

RCV Shipment Line Identifier
RCV_LINE_NUMBER NUMBER

RCV Line Number
FROM_ORGANIZATION_ID NUMBER
Y From Organization Identifier
TO_ORGANIZATION_ID NUMBER

To Organization Identifier
VENDOR_ID NUMBER

Vendor Identifier
SOURCE VARCHAR2 (240)
Vendor Name
VENDOR_SITE_ID NUMBER

Vendor Site Identifier
OUTSIDE_OPERATION_FLAG VARCHAR2 (1)
Indicates whether the PO line type is an outside operation or not
ITEM_ID NUMBER

Item Identifier
PRIMARY_UOM VARCHAR2 (25)
Primary Uom
PRIMARY_UOM_CLASS VARCHAR2 (10)
Primary Uom Class
ITEM_ALLOWED_UNITS_LOOKUP_CODE NUMBER

Allowed unit of measure conversion type
ITEM_LOCATOR_CONTROL NUMBER

Stock locator control code
RESTRICT_LOCATORS_CODE VARCHAR2 (1)
Locators restrictions type
RESTRICT_SUBINVENTORIES_CODE VARCHAR2 (1)
Subinventory restrictions type
SHELF_LIFE_CODE NUMBER

Shelf Life Code
SHELF_LIFE_DAYS NUMBER

Length of shelf life days
SERIAL_NUMBER_CONTROL_CODE NUMBER

Serial Number Control Code
LOT_CONTROL_CODE NUMBER

Lot Control Code
ITEM_REV_CONTROL_FLAG_TO VARCHAR2 (1)
Revision Quantity Control Code
ITEM_REV_CONTROL_FLAG_FROM VARCHAR2 (0)
Revision Quantity Control Code
ITEM_NUMBER VARCHAR2 (0)
Item Number
ITEM_REVISION VARCHAR2 (3)
Item Revision
ITEM_DESCRIPTION VARCHAR2 (240)
Item Description
ITEM_CATEGORY_ID NUMBER

Item Category Identifier
HAZARD_CLASS VARCHAR2 (40)
Hazard Class
UN_NUMBER VARCHAR2 (25)
United Nations number
VENDOR_ITEM_NUMBER VARCHAR2 (25)
Vendor Item Number
SHIP_TO_LOCATION_ID NUMBER

Ship to Location Identifier
SHIP_TO_LOCATION VARCHAR2 (60)
Ship to Location
PACKING_SLIP VARCHAR2 (0)
Packing Slip
ROUTING_ID NUMBER

Receipt routing unique identifier
ROUTING_NAME VARCHAR2 (80)
Receiving routing name
NEED_BY_DATE DATE

Need by date
EXPECTED_RECEIPT_DATE DATE

Expected Receipt Date
ORDERED_QTY NUMBER

Quantity ordered
ORDERED_UOM VARCHAR2 (25)
Unit of measure for the quantity ordered
USSGL_TRANSACTION_CODE VARCHAR2 (0)
USSGL Transaction Code
GOVERNMENT_CONTEXT VARCHAR2 (30)
USSGL descriptive flexfield context column
INSPECTION_REQUIRED_FLAG VARCHAR2 (1)
Indicates whether shipment must be inspected before the invoice is paid
RECEIPT_REQUIRED_FLAG VARCHAR2 (1)
Indicates whether shipment must be received before the invoice is paid
ENFORCE_SHIP_TO_LOCATION_CODE VARCHAR2 (25)
Describes what action is taken when the receiving location differs from the ship-to location
UNIT_PRICE NUMBER

Unit Price
CURRENCY_CODE VARCHAR2 (15)
Currency Code
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
Currency Conversion Type
CURRENCY_CONVERSION_DATE DATE

Currency Conversion Date
CURRENCY_CONVERSION_RATE NUMBER

Currency Conversion Rate
NOTE_TO_RECEIVER VARCHAR2 (480)
Shipment level Note to receiver, which would hold the note to receiver info coming from req lines
DESTINATION_TYPE_CODE VARCHAR2 (0)
Destination Type Code
DELIVER_TO_PERSON_ID NUMBER

Deliver to Person Identifier
DELIVER_TO_LOCATION_ID NUMBER

Deliver to Location Identifier
DESTINATION_SUBINVENTORY VARCHAR2 (0)
Destination Subinventory
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Attribute Category
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
CLOSED_CODE VARCHAR2 (30)
Closure status of the shipment
ASN_TYPE VARCHAR2 (0)
ASN Type
BILL_OF_LADING VARCHAR2 (0)
Bill Of Lading
SHIPPED_DATE DATE

Shipped Date
FREIGHT_CARRIER_CODE VARCHAR2 (0)
Freight Carrier Code
WAYBILL_AIRBILL_NUM VARCHAR2 (0)
Waybill Airbill Number
FREIGHT_BILL_NUM VARCHAR2 (0)
Freight Bill Number
VENDOR_LOT_NUM VARCHAR2 (0)
Vendor Lot Number
CONTAINER_NUM VARCHAR2 (0)
Container Number
TRUCK_NUM VARCHAR2 (0)
Truck Number
BAR_CODE_LABEL VARCHAR2 (0)
Bar Code Label
RATE_TYPE_DISPLAY VARCHAR2 (30)
Conversion type user defined name
MATCH_OPTION VARCHAR2 (25)
Indicator of whether the invoice for the shipment should be matched to the purchase order or the receipt
COUNTRY_OF_ORIGIN_CODE VARCHAR2 (2)
Country of manufacture for this shipment
OE_ORDER_HEADER_ID NUMBER

Order Header Identifier
OE_ORDER_NUM NUMBER

Order Number
OE_ORDER_LINE_ID NUMBER

Order Line Identifier
OE_ORDER_LINE_NUM NUMBER

Order Line Number
CUSTOMER_ID NUMBER

Customer Identifier
CUSTOMER_SITE_ID NUMBER

Customer Site Identifier
CUSTOMER_ITEM_NUM VARCHAR2 (0)
Customer Item Number
PLL_NOTE_TO_RECEIVER VARCHAR2 (480)
Shipment level Note to receiver, which would hold the note to receiver info coming from req lines
SECONDARY_ORDERED_QTY NUMBER

Secondary Quantity ordered
SECONDARY_ORDERED_UOM VARCHAR2 (25)
Secondary Unit of measure for the ordered item
QC_GRADE VARCHAR2 (150)
Preferred quality grade for the ordered item
LPN_ID NUMBER

License Plate Number Identifier of the item
SECONDARY_DEFAULT_IND VARCHAR2 (30)
Catch-Weight Support for 11.5.10
ORG_ID NUMBER

Operating Unit Identifier
OE_ORDER_SHIP_NUM NUMBER

Order Shipment Number
LCM_SHIPMENT_LINE_ID NUMBER

LCM Shipment Line Identifier
UNIT_LANDED_COST NUMBER

Unit Landed Cost
LCM_SHIPMENT_FLAG VARCHAR2 (1)
LCM Shipment Flag

[top of page]

APPS.INL_ENTER_RECEIPTS_V references the following:

APPS
SYNONYM - GL_DAILY_CONVERSION_TYPES
SYNONYM - HR_LOCATIONS_ALL_TL
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - PO_HAZARD_CLASSES_TL
SYNONYM - PO_HEADERS_ALL
SYNONYM - PO_LINES_ALL
SYNONYM - PO_LINE_LOCATIONS
SYNONYM - PO_LINE_TYPES_B
SYNONYM - PO_RELEASES_ALL
SYNONYM - PO_UN_NUMBERS_TL
VIEW - PO_VENDORS
- RCV_ROUTING_HEADERS
- MTL_UNITS_OF_MEASURE

APPS.INL_ENTER_RECEIPTS_V is not referenced by any database object

[top of page]

View: INL_ENTITIES_VL

Comments
Columns
Name Datatype Length Mandatory Comments
ENTITY_CODE VARCHAR2 (30) Y Entity Code
ENTITY_NAME VARCHAR2 (80) Y Entity Name
DESCRIPTION VARCHAR2 (240)
Description
TABLE_NAME VARCHAR2 (30)
Table Name
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y 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).

[top of page]

APPS.INL_ENTITIES_VL references the following:

APPS
SYNONYM - INL_ENTITIES_B
SYNONYM - INL_ENTITIES_TL

APPS.INL_ENTITIES_VL is not referenced by any database object

[top of page]

View: INL_IR_SOURCE_LINES_V

Comments
Columns
Name Datatype Length Mandatory Comments
LINE_CHKBOX CHAR (1)
SOURCE_TYPE_CODE CHAR (6)
RECEIPT_SOURCE_CODE CHAR (6)
ORDER_TYPE_CODE CHAR (2)
ORDER_TYPE VARCHAR2 (25) Y
PO_HEADER_ID NUMBER
Y
PO_NUMBER VARCHAR2 (20) Y
PO_LINE_ID NUMBER
Y
PO_LINE_NUMBER NUMBER
Y
PO_LINE_LOCATION_ID NUMBER
Y
PO_SHIPMENT_NUMBER NUMBER

PO_RELEASE_ID NUMBER

PO_RELEASE_NUMBER NUMBER

REQ_HEADER_ID NUMBER

REQ_NUMBER VARCHAR2 (0)
REQ_LINE_ID NUMBER

REQ_LINE NUMBER

REQ_DISTRIBUTION_ID NUMBER

RCV_SHIPMENT_HEADER_ID NUMBER

RCV_SHIPMENT_NUMBER VARCHAR2 (0)
RCV_SHIPMENT_LINE_ID NUMBER

RCV_LINE_NUMBER NUMBER

FROM_ORGANIZATION_ID NUMBER
Y
TO_ORGANIZATION_ID NUMBER

VENDOR_ID NUMBER

SOURCE VARCHAR2 (240)
VENDOR_SITE_ID NUMBER

OUTSIDE_OPERATION_FLAG VARCHAR2 (1)
ITEM_ID NUMBER

PRIMARY_UOM VARCHAR2 (25)
PRIMARY_UOM_CLASS VARCHAR2 (10)
ITEM_ALLOWED_UNITS_CODE NUMBER

ITEM_LOCATOR_CONTROL NUMBER

RESTRICT_LOCATORS_CODE VARCHAR2 (1)
RESTRICT_SUBINVENTORIES_CODE VARCHAR2 (1)
SHELF_LIFE_CODE NUMBER

SHELF_LIFE_DAYS NUMBER

SERIAL_NUMBER_CONTROL_CODE NUMBER

LOT_CONTROL_CODE NUMBER

ITEM_REV_CONTROL_FLAG_TO VARCHAR2 (1)
ITEM_REV_CONTROL_FLAG_FROM VARCHAR2 (0)
ITEM_NUMBER VARCHAR2 (0)
ITEM_REVISION VARCHAR2 (3)
ITEM_DESCRIPTION VARCHAR2 (240)
ITEM_CATEGORY_ID NUMBER

HAZARD_CLASS VARCHAR2 (40)
UN_NUMBER VARCHAR2 (25)
VENDOR_ITEM_NUMBER VARCHAR2 (25)
SHIP_TO_LOCATION_ID NUMBER

SHIP_TO_LOCATION VARCHAR2 (60)
PACKING_SLIP VARCHAR2 (0)
ROUTING_ID NUMBER

ROUTING_NAME VARCHAR2 (80)
NEED_BY_DATE DATE

EXPECTED_RECEIPT_DATE DATE

ORDERED_QTY NUMBER

ORDERED_UOM VARCHAR2 (25)
USSGL_TRANSACTION_CODE VARCHAR2 (0)
GOVERNMENT_CONTEXT VARCHAR2 (30)
INSPECTION_REQUIRED_FLAG VARCHAR2 (1)
RECEIPT_REQUIRED_FLAG VARCHAR2 (1)
ENFORCE_SHIP_TO_LOCATION_CODE VARCHAR2 (25)
UNIT_PRICE NUMBER

CURRENCY_CODE VARCHAR2 (15)
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
CURRENCY_CONVERSION_DATE DATE

CURRENCY_CONVERSION_RATE NUMBER

NOTE_TO_RECEIVER VARCHAR2 (480)
DESTINATION_TYPE_CODE VARCHAR2 (0)
DELIVER_TO_PERSON_ID NUMBER

DELIVER_TO_LOCATION_ID NUMBER

DESTINATION_SUBINVENTORY VARCHAR2 (0)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
CLOSED_CODE VARCHAR2 (30)
ASN_TYPE VARCHAR2 (0)
BILL_OF_LADING VARCHAR2 (0)
SHIPPED_DATE DATE

FREIGHT_CARRIER_CODE VARCHAR2 (0)
WAYBILL_AIRBILL_NUM VARCHAR2 (0)
FREIGHT_BILL_NUM VARCHAR2 (0)
VENDOR_LOT_NUM VARCHAR2 (0)
CONTAINER_NUM VARCHAR2 (0)
TRUCK_NUM VARCHAR2 (0)
BAR_CODE_LABEL VARCHAR2 (0)
RATE_TYPE_DISPLAY VARCHAR2 (30)
MATCH_OPTION VARCHAR2 (25)
COUNTRY_OF_ORIGIN_CODE VARCHAR2 (2)
OE_ORDER_HEADER_ID NUMBER

OE_ORDER_NUM NUMBER

OE_ORDER_LINE_ID NUMBER

OE_ORDER_LINE_NUM NUMBER

CUSTOMER_ID NUMBER

CUSTOMER_SITE_ID NUMBER

CUSTOMER_ITEM_NUM VARCHAR2 (0)
PLL_NOTE_TO_RECEIVER VARCHAR2 (480)
SECONDARY_ORDERED_QTY NUMBER

SECONDARY_ORDERED_UOM VARCHAR2 (25)
QC_GRADE VARCHAR2 (150)
LPN_ID NUMBER

SECONDARY_DEFAULT_IND VARCHAR2 (30)
ORG_ID NUMBER

OE_ORDER_SHIP_NUM NUMBER

[top of page]

APPS.INL_IR_SOURCE_LINES_V references the following:

- INL_ENTER_RECEIPTS_V

APPS.INL_IR_SOURCE_LINES_V is not referenced by any database object

[top of page]

View: INL_PO_CHARGES_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
CHARGE_ID NUMBER

Charge Identifier
SHIPMENT_HEADER_ID NUMBER

Shipment Identifier
SHIPMENT_LINE_ID NUMBER

Shipment Line Identifier
INTERFACE_CHARGE_ID NUMBER

Interface Charge Identifier
CREATION_DATE DATE

Standard who column - date when this row was created
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID)
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID)
COST_FACTOR_ID NUMBER

Cost Factor Identifier
CURRENCY_CODE VARCHAR2 (15)
Currency Code
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
Currency Conversion Type
CURRENCY_CONVERSION_RATE NUMBER

Currency Conversion Rate
CURRENCY_CONVERSION_DATE DATE

Currency Conversion Date
ALLOCATION_METHOD VARCHAR2 (30)
Allocation Method
UNIT_OF_MEASURE VARCHAR2 (25)
Unit of Measure
ESTIMATED_AMT NUMBER

Estimated Amount
ACTUAL_AMOUNT NUMBER

Actual Amount
INCLUDE_IN_ACQUISITION_COST VARCHAR2 (1)
Include in Acquisition Cost
VENDOR_ID NUMBER

Vendor Identifier
VENDOR_SITE_ID NUMBER

Vendor Site Identifier
ESTIMATED_TAX NUMBER

Estimated Tax
ACTUAL_TAX NUMBER

Actual Tax
COST_COMPONENT_CLASS_ID NUMBER

Cost Component Class Identifier
COST_ANALYSIS_CODE VARCHAR2 (15)
Cost Analysis Code

[top of page]

APPS.INL_PO_CHARGES_V references the following:

APPS
SYNONYM - INL_ALLOCATIONS
SYNONYM - INL_ASSOCIATIONS
SYNONYM - INL_CHARGE_LINES
PACKAGE - INL_SHIPMENT_PVT
SYNONYM - PO_HEADERS_ALL
SYNONYM - PO_RCV_CHARGES
SYNONYM - RCV_SHIPMENT_LINES
- PON_COST_FACTORS_VL

APPS.INL_PO_CHARGES_V is not referenced by any database object

[top of page]

View: INL_PO_CHARGE_ALLOCATIONS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
CHARGE_ALLOCATION_ID NUMBER

Charge Allocation Identifier
CHARGE_ID NUMBER

Charge Identifier
SHIPMENT_LINE_ID NUMBER

Shipment Line Identifier
CREATION_DATE DATE

Standard who column - date when this row was created.
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID)
ESTIMATED_AMOUNT NUMBER

Estimated Amount
ACTUAL_AMOUNT NUMBER

Actual Amount
ORIGINAL_UNIT_PRICE NUMBER

Original Unit Price
ORIGINAL_UNIT_NR_TAX NUMBER

Reserved for Costing use
EST_RECOVERABLE_TAX NUMBER

Estimated recoverable tax amount on this charge allocation
EST_NON_RECOVERABLE_TAX NUMBER

Estimated non_recoverable tax amount on this charge allocation
ACT_RECOVERABLE_TAX NUMBER

Actual recoverable tax amount on this charge allocation
ACT_NON_RECOVERABLE_TAX NUMBER

Actual non-recoverable tax amount on this charge allocation

[top of page]

APPS.INL_PO_CHARGE_ALLOCATIONS_V references the following:

APPS
SYNONYM - INL_ALLOCATIONS
SYNONYM - INL_CHARGE_LINES
PACKAGE - INL_SHIPMENT_PVT
SYNONYM - PO_LINE_LOCATIONS_ALL
SYNONYM - PO_RCV_CHARGE_ALLOCATIONS
SYNONYM - RCV_SHIPMENT_LINES

APPS.INL_PO_CHARGE_ALLOCATIONS_V is not referenced by any database object

[top of page]

View: INL_PO_SOURCE_LINES_V

Comments
Columns
Name Datatype Length Mandatory Comments
LINE_CHKBOX CHAR (1)
SOURCE_TYPE_CODE CHAR (6)
RECEIPT_SOURCE_CODE CHAR (6)
ORDER_TYPE_CODE CHAR (2)
ORDER_TYPE VARCHAR2 (25) Y
PO_HEADER_ID NUMBER
Y
PO_NUMBER VARCHAR2 (20) Y
PO_LINE_ID NUMBER
Y
PO_LINE_NUMBER NUMBER
Y
PO_LINE_LOCATION_ID NUMBER
Y
PO_SHIPMENT_NUMBER NUMBER

PO_RELEASE_ID NUMBER

PO_RELEASE_NUMBER NUMBER

REQ_HEADER_ID NUMBER

REQ_NUMBER VARCHAR2 (0)
REQ_LINE_ID NUMBER

REQ_LINE NUMBER

REQ_DISTRIBUTION_ID NUMBER

RCV_SHIPMENT_HEADER_ID NUMBER

RCV_SHIPMENT_NUMBER VARCHAR2 (0)
RCV_SHIPMENT_LINE_ID NUMBER

RCV_LINE_NUMBER NUMBER

FROM_ORGANIZATION_ID NUMBER
Y
TO_ORGANIZATION_ID NUMBER

VENDOR_ID NUMBER

SOURCE VARCHAR2 (240)
VENDOR_SITE_ID NUMBER

OUTSIDE_OPERATION_FLAG VARCHAR2 (1)
ITEM_ID NUMBER

PRIMARY_UOM VARCHAR2 (25)
PRIMARY_UOM_CLASS VARCHAR2 (10)
ITEM_ALLOWED_UNITS_CODE NUMBER

ITEM_LOCATOR_CONTROL NUMBER

RESTRICT_LOCATORS_CODE VARCHAR2 (1)
RESTRICT_SUBINVENTORIES_CODE VARCHAR2 (1)
SHELF_LIFE_CODE NUMBER

SHELF_LIFE_DAYS NUMBER

SERIAL_NUMBER_CONTROL_CODE NUMBER

LOT_CONTROL_CODE NUMBER

ITEM_REV_CONTROL_FLAG_TO VARCHAR2 (1)
ITEM_REV_CONTROL_FLAG_FROM VARCHAR2 (0)
ITEM_NUMBER VARCHAR2 (0)
ITEM_REVISION VARCHAR2 (3)
ITEM_DESCRIPTION VARCHAR2 (240)
ITEM_CATEGORY_ID NUMBER

HAZARD_CLASS VARCHAR2 (40)
UN_NUMBER VARCHAR2 (25)
VENDOR_ITEM_NUMBER VARCHAR2 (25)
SHIP_TO_LOCATION_ID NUMBER

SHIP_TO_LOCATION VARCHAR2 (60)
PACKING_SLIP VARCHAR2 (0)
ROUTING_ID NUMBER

ROUTING_NAME VARCHAR2 (80)
NEED_BY_DATE DATE

EXPECTED_RECEIPT_DATE DATE

ORDERED_QTY NUMBER

ORDERED_UOM VARCHAR2 (25)
USSGL_TRANSACTION_CODE VARCHAR2 (0)
GOVERNMENT_CONTEXT VARCHAR2 (30)
INSPECTION_REQUIRED_FLAG VARCHAR2 (1)
RECEIPT_REQUIRED_FLAG VARCHAR2 (1)
ENFORCE_SHIP_TO_LOCATION_CODE VARCHAR2 (25)
UNIT_PRICE NUMBER

CURRENCY_CODE VARCHAR2 (15)
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
CURRENCY_CONVERSION_DATE DATE

CURRENCY_CONVERSION_RATE NUMBER

NOTE_TO_RECEIVER VARCHAR2 (480)
DESTINATION_TYPE_CODE VARCHAR2 (0)
DELIVER_TO_PERSON_ID NUMBER

DELIVER_TO_LOCATION_ID NUMBER

DESTINATION_SUBINVENTORY VARCHAR2 (0)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
CLOSED_CODE VARCHAR2 (30)
ASN_TYPE VARCHAR2 (0)
BILL_OF_LADING VARCHAR2 (0)
SHIPPED_DATE DATE

FREIGHT_CARRIER_CODE VARCHAR2 (0)
WAYBILL_AIRBILL_NUM VARCHAR2 (0)
FREIGHT_BILL_NUM VARCHAR2 (0)
VENDOR_LOT_NUM VARCHAR2 (0)
CONTAINER_NUM VARCHAR2 (0)
TRUCK_NUM VARCHAR2 (0)
BAR_CODE_LABEL VARCHAR2 (0)
RATE_TYPE_DISPLAY VARCHAR2 (30)
MATCH_OPTION VARCHAR2 (25)
COUNTRY_OF_ORIGIN_CODE VARCHAR2 (2)
OE_ORDER_HEADER_ID NUMBER

OE_ORDER_NUM NUMBER

OE_ORDER_LINE_ID NUMBER

OE_ORDER_LINE_NUM NUMBER

CUSTOMER_ID NUMBER

CUSTOMER_SITE_ID NUMBER

CUSTOMER_ITEM_NUM VARCHAR2 (0)
PLL_NOTE_TO_RECEIVER VARCHAR2 (480)
SECONDARY_ORDERED_QTY NUMBER

SECONDARY_ORDERED_UOM VARCHAR2 (25)
QC_GRADE VARCHAR2 (150)
LPN_ID NUMBER

SECONDARY_DEFAULT_IND VARCHAR2 (30)
ORG_ID NUMBER

OE_ORDER_SHIP_NUM NUMBER

PARTY_ID NUMBER

PARTY_SITE_ID NUMBER (15)

[top of page]

APPS.INL_PO_SOURCE_LINES_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - PO_VENDORS
- PO_VENDOR_SITES_ALL
- INL_ENTER_RECEIPTS_V

APPS.INL_PO_SOURCE_LINES_V is not referenced by any database object

[top of page]

View: INL_RMA_SOURCE_LINES_V

Comments
Columns
Name Datatype Length Mandatory Comments
LINE_CHKBOX CHAR (1)
SOURCE_TYPE_CODE CHAR (6)
RECEIPT_SOURCE_CODE CHAR (6)
ORDER_TYPE_CODE CHAR (2)
ORDER_TYPE VARCHAR2 (25) Y
PO_HEADER_ID NUMBER
Y
PO_NUMBER VARCHAR2 (20) Y
PO_LINE_ID NUMBER
Y
PO_LINE_NUMBER NUMBER
Y
PO_LINE_LOCATION_ID NUMBER
Y
PO_SHIPMENT_NUMBER NUMBER

PO_RELEASE_ID NUMBER

PO_RELEASE_NUMBER NUMBER

REQ_HEADER_ID NUMBER

REQ_NUMBER VARCHAR2 (0)
REQ_LINE_ID NUMBER

REQ_LINE NUMBER

REQ_DISTRIBUTION_ID NUMBER

RCV_SHIPMENT_HEADER_ID NUMBER

RCV_SHIPMENT_NUMBER VARCHAR2 (0)
RCV_SHIPMENT_LINE_ID NUMBER

RCV_LINE_NUMBER NUMBER

FROM_ORGANIZATION_ID NUMBER
Y
TO_ORGANIZATION_ID NUMBER

VENDOR_ID NUMBER

SOURCE VARCHAR2 (240)
VENDOR_SITE_ID NUMBER

OUTSIDE_OPERATION_FLAG VARCHAR2 (1)
ITEM_ID NUMBER

PRIMARY_UOM VARCHAR2 (25)
PRIMARY_UOM_CLASS VARCHAR2 (10)
ITEM_ALLOWED_UNITS_CODE NUMBER

ITEM_LOCATOR_CONTROL NUMBER

RESTRICT_LOCATORS_CODE VARCHAR2 (1)
RESTRICT_SUBINVENTORIES_CODE VARCHAR2 (1)
SHELF_LIFE_CODE NUMBER

SHELF_LIFE_DAYS NUMBER

SERIAL_NUMBER_CONTROL_CODE NUMBER

LOT_CONTROL_CODE NUMBER

ITEM_REV_CONTROL_FLAG_TO VARCHAR2 (1)
ITEM_REV_CONTROL_FLAG_FROM VARCHAR2 (0)
ITEM_NUMBER VARCHAR2 (0)
ITEM_REVISION VARCHAR2 (3)
ITEM_DESCRIPTION VARCHAR2 (240)
ITEM_CATEGORY_ID NUMBER

HAZARD_CLASS VARCHAR2 (40)
UN_NUMBER VARCHAR2 (25)
VENDOR_ITEM_NUMBER VARCHAR2 (25)
SHIP_TO_LOCATION_ID NUMBER

SHIP_TO_LOCATION VARCHAR2 (60)
PACKING_SLIP VARCHAR2 (0)
ROUTING_ID NUMBER

ROUTING_NAME VARCHAR2 (80)
NEED_BY_DATE DATE

EXPECTED_RECEIPT_DATE DATE

ORDERED_QTY NUMBER

ORDERED_UOM VARCHAR2 (25)
USSGL_TRANSACTION_CODE VARCHAR2 (0)
GOVERNMENT_CONTEXT VARCHAR2 (30)
INSPECTION_REQUIRED_FLAG VARCHAR2 (1)
RECEIPT_REQUIRED_FLAG VARCHAR2 (1)
ENFORCE_SHIP_TO_LOCATION_CODE VARCHAR2 (25)
UNIT_PRICE NUMBER

CURRENCY_CODE VARCHAR2 (15)
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
CURRENCY_CONVERSION_DATE DATE

CURRENCY_CONVERSION_RATE NUMBER

NOTE_TO_RECEIVER VARCHAR2 (480)
DESTINATION_TYPE_CODE VARCHAR2 (0)
DELIVER_TO_PERSON_ID NUMBER

DELIVER_TO_LOCATION_ID NUMBER

DESTINATION_SUBINVENTORY VARCHAR2 (0)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
CLOSED_CODE VARCHAR2 (30)
ASN_TYPE VARCHAR2 (0)
BILL_OF_LADING VARCHAR2 (0)
SHIPPED_DATE DATE

FREIGHT_CARRIER_CODE VARCHAR2 (0)
WAYBILL_AIRBILL_NUM VARCHAR2 (0)
FREIGHT_BILL_NUM VARCHAR2 (0)
VENDOR_LOT_NUM VARCHAR2 (0)
CONTAINER_NUM VARCHAR2 (0)
TRUCK_NUM VARCHAR2 (0)
BAR_CODE_LABEL VARCHAR2 (0)
RATE_TYPE_DISPLAY VARCHAR2 (30)
MATCH_OPTION VARCHAR2 (25)
COUNTRY_OF_ORIGIN_CODE VARCHAR2 (2)
OE_ORDER_HEADER_ID NUMBER

OE_ORDER_NUM NUMBER

OE_ORDER_LINE_ID NUMBER

OE_ORDER_LINE_NUM NUMBER

CUSTOMER_ID NUMBER

CUSTOMER_SITE_ID NUMBER

CUSTOMER_ITEM_NUMBER VARCHAR2 (0)
PLL_NOTE_TO_RECEIVER VARCHAR2 (480)
SECONDARY_ORDERED_QTY NUMBER

SECONDARY_ORDERED_UOM VARCHAR2 (25)
QC_GRADE VARCHAR2 (150)
LPN_ID NUMBER

SECONDARY_DEFAULT_IND VARCHAR2 (30)
ORG_ID NUMBER

OE_ORDER_SHIP_NUM NUMBER

PARTY_ID NUMBER (15)

[top of page]

APPS.INL_RMA_SOURCE_LINES_V references the following:

- INL_ENTER_RECEIPTS_V
- ARPT_SQL_FUNC_UTIL
- HZ_CUSTOMER_PARTY_FIND_V

APPS.INL_RMA_SOURCE_LINES_V is not referenced by any database object

[top of page]

View: INL_RULES_VL

Comments
Columns
Name Datatype Length Mandatory Comments
RULE_ID NUMBER
Y Rule Identifier
RULE_NAME VARCHAR2 (30) Y Rule Name
PACKAGE_NAME VARCHAR2 (100)
Package Name
USAGE_CODE VARCHAR2 (30) Y Usage Code
ENABLED_FLAG VARCHAR2 (1)
Enabled Flag
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y 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).

[top of page]

APPS.INL_RULES_VL references the following:

APPS
SYNONYM - INL_RULES_B
SYNONYM - INL_RULES_TL

APPS.INL_RULES_VL is not referenced by any database object

[top of page]

View: INL_SHIPLN_LANDED_COSTS_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
SHIP_HEADER_ID NUMBER
Y Shipment Identifier
SHIP_LINE_GROUP_ID NUMBER

Line Group Identifier
ADJUSTMENT_NUM NUMBER
Y Adjustment Number
SHIP_LINE_ID NUMBER

Shipment Line Identifier
SHIP_LINE_NUM NUMBER

Shipment Line Number
ORGANIZATION_ID NUMBER
Y Inventory Organization Identifier
INVENTORY_ITEM_ID NUMBER

Inventory Item Identifier
ITEM_PRICE NUMBER

Item Price
CHARGES NUMBER

Amount of Charges
TAXES NUMBER

Taxes Amount
PRIMARY_QTY NUMBER

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

Unit Landed Cost

[top of page]

APPS.INL_SHIPLN_LANDED_COSTS_V references the following:

APPS
SYNONYM - INL_ALLOCATIONS
SYNONYM - INL_ASSOCIATIONS
SYNONYM - INL_SHIP_HEADERS_ALL
SYNONYM - INL_SHIP_LINES_ALL

APPS.INL_SHIPLN_LANDED_COSTS_V is not referenced by any database object

[top of page]

View: INL_SHIP_IR_OVERALL_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
SHIP_HEADER_ID NUMBER

Shipment Identifier
ORGANIZATION_ID NUMBER

Inventory Organization Identifier
LOCATION_ID NUMBER

Location Identifier
ORG_ID NUMBER

Operating Unit Identifier
SHIP_TYPE_ID NUMBER

Shipment Type Identifier
SHIP_TYPE_CODE VARCHAR2 (15)
Shipment Type Code
SHIP_TYPE_NAME VARCHAR2 (30)
Shipment Type Name
SHIP_NUM VARCHAR2 (25)
Shipment Number
SHIP_DATE DATE

Shipment Date
SHIP_STATUS_CODE VARCHAR2 (30)
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
PENDING_UPDATE_FLAG VARCHAR2 (1)
"Y" or "N" flag indicating the existence of lines updated but not processed by the landed cost calculation
SIMULATION_ID NUMBER

Simulation Identifier
SHIP_LINE_GROUP_ID NUMBER

Line Group Identifier
SHIP_LINE_GROUP_NUM NUMBER

Line Group Number
SHIP_LINE_GROUP_REFERENCE VARCHAR2 (30)
Line Group Reference
SRC_TYPE_CODE VARCHAR2 (30)
GROUP_PARTY_ID NUMBER

Group Party Identifier
GROUP_PARTY_NAME VARCHAR2 (360)
Group Party Name
GROUP_PARTY_SITE_ID NUMBER

Group Party Site Identifier
GROUP_PARTY_SITE_NAME VARCHAR2 (240)
GROUP_ORGANIZATION_ID NUMBER

Group Organization Identifier
GROUP_ORGANIZATION_NAME VARCHAR2 (240)
Group Organization Name
SHIP_LINE_ID NUMBER

Shipment Line Identifier
SHIP_LINE_NUM NUMBER

Shipment Line Number
EST_SHIP_LINE_ID NUMBER

Estimated Shipment Line Identifier
EST_TXN_UNIT_PRICE NUMBER

Estimated Transaction Unit Price
SHIP_LINE_SRC_TYPE_CODE VARCHAR2 (30)
Source Type Code, taken from lookup INL_SHIP_LINE_SRC_TYPES
SHIP_LINE_SOURCE_ID NUMBER

Shipment Line Source Identifier
SHIP_LINE_TYPE_CODE VARCHAR2 (15)
Shipment Line Type Code
SHIP_LINE_TYPE_NAME VARCHAR2 (30)
Shipment Line Type Name
ITEM_ID NUMBER

Inventory Item Identifier
ITEM VARCHAR2 (40)
Item
ITEM_REVISION VARCHAR2 (0)
Item Revision
ITEM_DESCRIPTION VARCHAR2 (240)
Item Revision
TXN_QTY NUMBER

Transaction Quantity
TXN_UOM_CODE VARCHAR2 (3)
PRIMARY_UOM_CODE VARCHAR2 (3)
Primary Unit of Measure Code
PRIMARY_QTY NUMBER

Primary Quantity
SECONDARY_UOM_CODE VARCHAR2 (3)
Secondary Unit of Measure
SECONDARY_QTY NUMBER

Secondary Quantity
TXN_UNIT_PRICE NUMBER

Transaction Unit Price
CURRENCY_CODE VARCHAR2 (15)
Currency Code
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
Currency Conversion Type
CURRENCY_CONVERSION_DATE DATE

Currency Conversion Date
CURRENCY_CONVERSION_RATE NUMBER

Currency Conversion Rate
LINE_AMT NUMBER

Line Amount
SRC_ID NUMBER

Source Identifier
SRC_TYPE VARCHAR2 (0)
Source Type
SRC_NUMBER VARCHAR2 (40)
Source Number
SRC_DESCRIPTION VARCHAR2 (240)
Source Description
SRC_ORG_ID NUMBER

Source Operating Unit Identifier
SRC_PARTY_ID NUMBER

Source Party Identifier
SRC_PARTY_NAME VARCHAR2 (360)
Source Party Name
SRC_PARTY_SITE_ID NUMBER

Source Party Site Identifier
SRC_PARTY_SITE_NAME VARCHAR2 (0)
Source Party Site Name
SRC_VENDOR_ID NUMBER

Source Vendor Identifier
SRC_VENDOR_NAME VARCHAR2 (0)
Source Vendor Name
SRC_VENDOR_SITE_ID NUMBER

Source Vendor Site Identifier
SRC_VENDOR_SITE_CODE VARCHAR2 (0)
Source Vendor Site Code
SRC_ORGANIZATION_ID NUMBER

Source Inventory Organization Identifier
SRC_LOCATION_ID NUMBER

Source Location Identifier
SRC_CUSTOMER_ID VARCHAR2 (0)
SRC_CUSTOMER_NAME VARCHAR2 (0)
Source Customer Name
SRC_CUSTOMER_NUMBER VARCHAR2 (0)
Source Customer Number
SRC_CUSTOMER_SITE_CODE VARCHAR2 (0)
Source Customer Site Code
SRC_CUST_ITEM_NUM VARCHAR2 (0)
Source Customer Item Number
SRC_RELEASE_NUM NUMBER

Source Release Number
SRC_RELEASE_ID NUMBER

Source Release Identifier
SRC_RELEASE_DATE DATE

Source Release Date
SRC_LINE_ID NUMBER

Source Line Identifier
SRC_LINE_NUM NUMBER

Source Line Number
SRC_SHIP_ID NUMBER

Source Shipment Identifier
SRC_SHIP_NUM VARCHAR2 (30)
Source Shipment Number
SRC_SHIPPED_DATE DATE

Source Shipped Date
SRC_QTY NUMBER

Source Quantity
SRC_ITEM_ID NUMBER

Source Inventory Item Identifier
SRC_ITEM_REVISION VARCHAR2 (3)
Source Item Revision
SRC_ITEM_DESCRIPTION VARCHAR2 (240)
Source Item Description
SRC_CONTAINER_NUM VARCHAR2 (35)
Source Container Number
SRC_TRUCK_NUM VARCHAR2 (35)
Source Truck Number
SRC_BAR_CODE_LABEL VARCHAR2 (35)
Source Bar Code Label
SRC_DELIVER_TO_PERSON_ID NUMBER

Source Deliver To Person Identifier
SRC_VENDOR_ITEM_NUM VARCHAR2 (25)
Source Vendor Item Number
SRC_PACKING_SLIP VARCHAR2 (25)
Source Packing Slip
SRC_EMPLOYEE_ID NUMBER

Source Employee Identifier
SRC_FREIGHT_CARRIER_CODE VARCHAR2 (25)
Source Freight Carrier Code
SRC_BILL_OF_LADING VARCHAR2 (25)
Source Bill Of Lading
SRC_ROUTING_ID NUMBER

Source Routing Identifier
SRC_INSPECTION_STATUS_CODE VARCHAR2 (25)
Source Inspection Status Code
SRC_TRANSACTION_DATE DATE

Source Transaction Date

[top of page]

APPS.INL_SHIP_IR_OVERALL_V references the following:

APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
SYNONYM - INL_SHIP_HEADERS
SYNONYM - INL_SHIP_LINES
SYNONYM - INL_SHIP_LINE_GROUPS
SYNONYM - PO_REQUISITION_HEADERS
SYNONYM - PO_REQUISITION_LINES
SYNONYM - RCV_SHIPMENT_HEADERS
SYNONYM - RCV_SHIPMENT_LINES
SYNONYM - RCV_SUPPLY
SYNONYM - RCV_TRANSACTIONS
- INL_SHIP_TYPES_VL
- INL_SHIP_OVERALL_V
- MTL_SYSTEM_ITEMS_VL
- ORG_ORGANIZATION_DEFINITIONS
- INL_ADJ_SHIP_LINES_V
- INL_SHIP_LINE_TYPES_VL

APPS.INL_SHIP_IR_OVERALL_V is not referenced by any database object

[top of page]

View: INL_SHIP_LANDED_COSTS_V

Comments
Columns
Name Datatype Length Mandatory Comments
SHIP_HEADER_ID NUMBER
Y
ADJUSTMENT_NUM NUMBER
Y
ORGANIZATION_ID NUMBER
Y
INVENTORY_ITEM_ID NUMBER

ITEM_PRICE NUMBER

CHARGES NUMBER

TAXES NUMBER

PRIMARY_QTY NUMBER

PRIMARY_UOM_CODE VARCHAR2 (3)
UNIT_LANDED_COST NUMBER

[top of page]

APPS.INL_SHIP_LANDED_COSTS_V references the following:

- INL_SHIPLN_LANDED_COSTS_V

APPS.INL_SHIP_LANDED_COSTS_V is not referenced by any database object

[top of page]

View: INL_SHIP_LINE_TYPES_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

This view shows Shipment Line Type information in a given language.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row Identifier
SHIP_LINE_TYPE_ID NUMBER
Y Shipment Line Type Identifier
SHIP_LINE_TYPE_CODE VARCHAR2 (15) Y Shipment Line Type Code
SHIP_LINE_TYPE_NAME VARCHAR2 (30) Y Shipment Line Type Name
DFLT_LANDED_COST_FLAG VARCHAR2 (1) Y "Y" or "N" flag indicating whether the amounts of the line should be considered in the landed cost
DFLT_ALLOCATION_ENABLED_FLAG VARCHAR2 (1) Y "Y" or "N" flag indicating whether the amounts of the line are associable
ACTIVE_FROM_DATE DATE
Y Active From Date
ACTIVE_TO_DATE DATE

Active To Date
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y 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).
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

[top of page]

APPS.INL_SHIP_LINE_TYPES_VL references the following:

APPS
SYNONYM - INL_SHIP_LINE_TYPES_B
SYNONYM - INL_SHIP_LINE_TYPES_TL

APPS.INL_SHIP_LINE_TYPES_VL is not referenced by any database object

[top of page]

View: INL_SHIP_OVERALL_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
SHIP_HEADER_ID NUMBER

Shipment Header Identifier
ORGANIZATION_ID NUMBER

Inventory Organization Identifier
LOCATION_ID NUMBER

Location Identifier
ORG_ID NUMBER

Organization Identifier
SHIP_TYPE_ID NUMBER

Shipment Type Identifier
SHIP_TYPE_CODE VARCHAR2 (15)
Shipment Type Code
SHIP_TYPE_NAME VARCHAR2 (30)
Shipment Type Name
SHIP_NUM VARCHAR2 (25)
Shipment Number
SHIP_DATE DATE

Shipment Date
SHIP_STATUS_CODE VARCHAR2 (30)
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
PENDING_UPDATE_FLAG VARCHAR2 (1)
"Y" or "N" flag indicating the existence of lines updated but not processed by the landed cost calculation
SIMULATION_ID NUMBER

Simulation Identifier
SHIP_LINE_GROUP_ID NUMBER

Line Group Identifier
SHIP_LINE_GROUP_NUM NUMBER

Line Group Number
SHIP_LINE_GROUP_REFERENCE VARCHAR2 (30)
Line Group Reference
SRC_TYPE_CODE VARCHAR2 (30)
Source Type Code
GROUP_PARTY_ID NUMBER

Group Party Identifier
GROUP_PARTY_NAME VARCHAR2 (360)
Group Party Name
GROUP_PARTY_SITE_ID NUMBER

Group Party Site Identifier
GROUP_PARTY_SITE_NAME VARCHAR2 (240)
Group Party Site Name
GROUP_ORGANIZATION_ID NUMBER

Group Organization Identifier
GROUP_ORGANIZATION_NAME VARCHAR2 (240)
Group Organization Name
SHIP_LINE_ID NUMBER

Shipment Line Identifier
SHIP_LINE_NUM NUMBER

Shipment Line Number
EST_SHIP_LINE_ID NUMBER

Estimated Shipment Line Identifier
EST_TXN_UNIT_PRICE NUMBER

Estimated Transaction Unit Price
SHIP_LINE_SRC_TYPE_CODE VARCHAR2 (30)
Source Type Code, taken from lookup INL_SHIP_LINE_SRC_TYPES
SHIP_LINE_SOURCE_ID NUMBER

Shipment Line Source Identifier
SHIP_LINE_TYPE_CODE VARCHAR2 (15)
Shipment Line Type Code
SHIP_LINE_TYPE_NAME VARCHAR2 (30)
Shipment Line Type Name
ITEM_ID NUMBER

Inventory Item Identifier
ITEM VARCHAR2 (40)
Item
ITEM_REVISION VARCHAR2 (0)
Item Revision
ITEM_DESCRIPTION VARCHAR2 (240)
Item Description
TXN_QTY NUMBER

Transaction Quantity
TXN_UOM_CODE VARCHAR2 (3)
Transaction Unit of Measure
PRIMARY_UOM_CODE VARCHAR2 (3)
Primary Unit of Measure Code
PRIMARY_QTY NUMBER

Primary Quantity
SECONDARY_UOM_CODE VARCHAR2 (3)
Secondary Unit of Measure
SECONDARY_QTY NUMBER

Secondary Quantity
TXN_UNIT_PRICE NUMBER

Transaction Unit Price
CURRENCY_CODE VARCHAR2 (15)
Currency Code
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
Currency Conversion Type
CURRENCY_CONVERSION_DATE DATE

Currency Conversion Date
CURRENCY_CONVERSION_RATE NUMBER

Currency Conversion Rate
LINE_AMT NUMBER

Line Amount
SRC_ID NUMBER

Source Identifier
SRC_TYPE VARCHAR2 (0)
Source Type
SRC_NUMBER VARCHAR2 (40)
Source Number
SRC_DESCRIPTION VARCHAR2 (0)
Source Description
SRC_ORG_ID NUMBER

Source Operating Unit Identifier
SRC_PARTY_ID NUMBER

Source Party Identifier
SRC_PARTY_NAME VARCHAR2 (360)
Source Party Name
SRC_PARTY_SITE_ID VARCHAR2 (0)
Source Party Site Identifier
SRC_PARTY_SITE_NAME VARCHAR2 (0)
Source Party Site Name
SRC_VENDOR_ID VARCHAR2 (0)
Source Vendor Identifier
SRC_VENDOR_NAME VARCHAR2 (0)
Source Vendor Name
SRC_VENDOR_SITE_ID VARCHAR2 (0)
Source Vendor Site Identifier
SRC_VENDOR_SITE_CODE VARCHAR2 (0)
Source Vendor Site Code
SRC_ORGANIZATION_ID NUMBER

Source Inventory Organization Identifier
SRC_LOCATION_ID VARCHAR2 (0)
Source Location Identifier
SRC_CUSTOMER_ID VARCHAR2 (0)
Source Customer Identifier
SRC_CUSTOMER_NAME VARCHAR2 (0)
Source Customer Name
SRC_CUSTOMER_NUMBER VARCHAR2 (0)
Source Customer Number
SRC_CUSTOMER_SITE_CODE VARCHAR2 (0)
Source Customer Site Code
SRC_CUST_ITEM_NUM VARCHAR2 (0)
Source Customer Item Number
SRC_RELEASE_NUM VARCHAR2 (0)
Source Release Number
SRC_RELEASE_ID VARCHAR2 (0)
Source Release Identifier
SRC_RELEASE_DATE VARCHAR2 (0)
Source Release Date
SRC_LINE_ID NUMBER

Source Line Identifier
SRC_LINE_NUM NUMBER

Source Line Number
SRC_SHIP_ID VARCHAR2 (0)
Source Shipment Identifier
SRC_SHIP_NUM VARCHAR2 (0)
Source Shipment Number
SRC_SHIPPED_DATE VARCHAR2 (0)
Source Shipped Date
SRC_QTY VARCHAR2 (0)
Source Quantity
SRC_ITEM_ID NUMBER

Source Inventory Item Identifier
SRC_ITEM_REVISION VARCHAR2 (0)
Source Item Revision
SRC_ITEM_DESCRIPTION VARCHAR2 (240)
Source Item Description
SRC_CONTAINER_NUM VARCHAR2 (0)
Source Container Number
SRC_TRUCK_NUM VARCHAR2 (0)
Source Truck Number
SRC_BAR_CODE_LABEL VARCHAR2 (0)
Source Bar Code Label
SRC_DELIVER_TO_PERSON_ID VARCHAR2 (0)
Source Deliver To Person Identifier
SRC_VENDOR_ITEM_NUM VARCHAR2 (0)
Source Vendor Item Number
SRC_PACKING_SLIP VARCHAR2 (0)
Source Packing Slip
SRC_EMPLOYEE_ID NUMBER

Source Employee Identifier
SRC_FREIGHT_CARRIER_CODE VARCHAR2 (0)
Source Freight Carrier Code
SRC_BILL_OF_LADING VARCHAR2 (0)
Source Bill Of Lading
SRC_ROUTING_ID VARCHAR2 (0)
Source Routing Identifier
SRC_INSPECTION_STATUS_CODE VARCHAR2 (0)
Source Inspection Status Code
SRC_TRANSACTION_DATE DATE

Source Transaction Date

[top of page]

APPS.INL_SHIP_OVERALL_V references the following:

APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
SYNONYM - HZ_PARTIES
SYNONYM - HZ_PARTY_SITES
VIEW - INL_ADJ_SHIP_LINES_V
SYNONYM - INL_SHIP_HEADERS
SYNONYM - INL_SHIP_LINE_GROUPS
VIEW - INL_SHIP_TYPES_VL
- INL_SHIP_LINE_TYPES_VL
- MTL_SYSTEM_ITEMS_VL
- ORG_ORGANIZATION_DEFINITIONS

APPS.INL_SHIP_OVERALL_V is not referenced by any database object

[top of page]

View: INL_SHIP_PO_OVERALL_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
SHIP_HEADER_ID NUMBER
Y Shipment Identifier
ORGANIZATION_ID NUMBER
Y Inventory Organization Identifier
LOCATION_ID NUMBER

Location Identifier
ORG_ID NUMBER
Y Operating Unit Identifier
SHIP_TYPE_ID NUMBER
Y Shipment Type Identifier
SHIP_TYPE_CODE VARCHAR2 (15)
Shipment Type Code
SHIP_TYPE_NAME VARCHAR2 (30)
Shipment Type Name
SHIP_NUM VARCHAR2 (25) Y Shipment Number
SHIP_DATE DATE
Y Shipment Date
SHIP_STATUS_CODE VARCHAR2 (30) Y 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
PENDING_UPDATE_FLAG VARCHAR2 (1)
"Y" or "N" flag indicating the existence of lines updated but not processed by the landed cost calculation
SIMULATION_ID NUMBER

Simulation Identifier
SHIP_LINE_GROUP_ID NUMBER

Line Group Identifier
SHIP_LINE_GROUP_NUM NUMBER

Line Group Number
SHIP_LINE_GROUP_REFERENCE VARCHAR2 (30)
Line Group Reference
SRC_TYPE_CODE VARCHAR2 (30)
Source Type Code
GROUP_PARTY_ID NUMBER

Group Party Identifier
GROUP_PARTY_NAME VARCHAR2 (360)
Group Party Name
GROUP_PARTY_SITE_ID NUMBER

Group Party Site Identifier
GROUP_PARTY_SITE_NAME VARCHAR2 (240)
Group Party Site Name
GROUP_ORGANIZATION_ID VARCHAR2 (0)
Group Organization Identifier
GROUP_ORGANIZATION_NAME VARCHAR2 (0)
Group Organization Name
SHIP_LINE_ID NUMBER

Shipment Line Identifier
SHIP_LINE_NUM NUMBER

Shipment Line Number
EST_SHIP_LINE_ID NUMBER

Estimated Shipment Line Identifier
EST_TXN_UNIT_PRICE NUMBER

Estimated Transaction Unit Price
SHIP_LINE_SRC_TYPE_CODE VARCHAR2 (30)
Source Type Code, taken from lookup INL_SHIP_LINE_SRC_TYPES
SHIP_LINE_SOURCE_ID NUMBER

Shipment Line Source Identifier
SHIP_LINE_TYPE_CODE VARCHAR2 (15)
Shipment Line Type Code
SHIP_LINE_TYPE_NAME VARCHAR2 (30)
Shipment Line Type Name
ITEM_ID NUMBER

Inventory Item Identifier
ITEM VARCHAR2 (40)
Item
ITEM_REVISION VARCHAR2 (3)
Item Revision
ITEM_DESCRIPTION VARCHAR2 (240)
Item Description
TXN_QTY NUMBER

Transaction Quantity
TXN_UOM_CODE VARCHAR2 (3)
Transaction Unit of Measure
PRIMARY_UOM_CODE VARCHAR2 (3)
Primary Unit of Measure Code
PRIMARY_QTY NUMBER

Primary Quantity
SECONDARY_UOM_CODE VARCHAR2 (3)
Secondary Unit of Measure
SECONDARY_QTY NUMBER

Secondary Quantity
TXN_UNIT_PRICE NUMBER

Transaction Unit Price
CURRENCY_CODE VARCHAR2 (15)
Currency Code
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
Currency Conversion Type
CURRENCY_CONVERSION_DATE DATE

Currency Conversion Date
CURRENCY_CONVERSION_RATE NUMBER

Currency Conversion Rate
LINE_AMT NUMBER

Line Amount
SRC_ID NUMBER

Source Identifier
SRC_TYPE VARCHAR2 (80)
Source Type
SRC_NUMBER VARCHAR2 (20)
Source Number
SRC_DESCRIPTION VARCHAR2 (0)
Source Description
SRC_ORG_ID NUMBER

Source Operating Unit Identifier
SRC_PARTY_ID NUMBER

Source Party Identifier
SRC_PARTY_NAME VARCHAR2 (360)
Source Party Name
SRC_PARTY_SITE_ID NUMBER (15)
Source Party Site Identifier
SRC_PARTY_SITE_NAME VARCHAR2 (240)
Source Party Site Name
SRC_VENDOR_ID NUMBER

Source Vendor Identifier
SRC_VENDOR_NAME VARCHAR2 (240)
Source Vendor Name
SRC_VENDOR_SITE_ID NUMBER

Source Vendor Site Identifier
SRC_VENDOR_SITE_CODE VARCHAR2 (15)
Source Vendor Site Code
SRC_ORGANIZATION_ID VARCHAR2 (0)
Source Inventory Organization Identifier
SRC_LOCATION_ID VARCHAR2 (0)
Source Location Identifier
SRC_CUSTOMER_ID VARCHAR2 (0)
Source Customer Identifier
SRC_CUSTOMER_NAME VARCHAR2 (0)
Source Customer Name
SRC_CUSTOMER_NUMBER VARCHAR2 (0)
Source Customer Number
SRC_CUSTOMER_SITE_CODE VARCHAR2 (0)
Source Customer Site Code
SRC_CUST_ITEM_NUM VARCHAR2 (0)
Source Customer Item Number
SRC_RELEASE_NUM NUMBER

Source Release Number
SRC_RELEASE_ID NUMBER

Source Release Identifier
SRC_RELEASE_DATE DATE

Source Release Date
SRC_LINE_ID NUMBER

Source Line Identifier
SRC_LINE_NUM NUMBER

Source Line Number
SRC_SHIP_ID NUMBER

Source Shipment Identifier
SRC_SHIP_NUM VARCHAR2 (40)
Source Shipment Number
SRC_SHIPPED_DATE VARCHAR2 (0)
Source Shipped Date
SRC_QTY NUMBER

Source Quantity
SRC_ITEM_ID NUMBER

Source Inventory Item Identifier
SRC_ITEM_REVISION VARCHAR2 (3)
Source Item Revision
SRC_ITEM_DESCRIPTION VARCHAR2 (240)
Source Item Description
SRC_CONTAINER_NUM VARCHAR2 (35)
Source Container Number
SRC_TRUCK_NUM VARCHAR2 (35)
Source Truck Number
SRC_BAR_CODE_LABEL VARCHAR2 (35)
Source Bar Code Label
SRC_DELIVER_TO_PERSON_ID NUMBER (9)
Source Deliver To Person Identifier
SRC_VENDOR_ITEM_NUM VARCHAR2 (25)
Source Vendor Item Number
SRC_PACKING_SLIP VARCHAR2 (25)
Source Packing Slip
SRC_EMPLOYEE_ID NUMBER (9)
Source Employee Identifier
SRC_FREIGHT_CARRIER_CODE VARCHAR2 (25)
Source Freight Carrier Code
SRC_BILL_OF_LADING VARCHAR2 (25)
Source Bill Of Lading
SRC_ROUTING_ID NUMBER

Source Routing Identifier
SRC_INSPECTION_STATUS_CODE VARCHAR2 (25)
Source Inspection Status Code
SRC_TRANSACTION_DATE DATE

Source Transaction Date

[top of page]

APPS.INL_SHIP_PO_OVERALL_V references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - HZ_PARTIES
SYNONYM - HZ_PARTY_SITES
SYNONYM - INL_SHIP_HEADERS
SYNONYM - INL_SHIP_LINES
SYNONYM - INL_SHIP_LINE_GROUPS
SYNONYM - PO_HEADERS
SYNONYM - PO_LINES
SYNONYM - PO_LINE_LOCATIONS
SYNONYM - PO_RELEASES
VIEW - PO_VENDORS
SYNONYM - RCV_SHIPMENT_HEADERS
SYNONYM - RCV_SHIPMENT_LINES
SYNONYM - RCV_SUPPLY
SYNONYM - RCV_TRANSACTIONS
- INL_SHIP_LINE_TYPES_VL
- PO_VENDOR_SITES
- INL_ADJ_SHIP_LINES_V
- MTL_SYSTEM_ITEMS_VL
- INL_SHIP_TYPES_VL
- PO_LOOKUP_CODES

APPS.INL_SHIP_PO_OVERALL_V is not referenced by any database object

[top of page]

View: INL_SHIP_RMA_OVERALL_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
SHIP_HEADER_ID NUMBER

Shipment Identifier
ORGANIZATION_ID NUMBER

Inventory Organization Identifier
LOCATION_ID NUMBER

Location Identifier
ORG_ID NUMBER

Operating Unit Identifier
SHIP_TYPE_ID NUMBER

Shipment Type Identifier
SHIP_TYPE_CODE VARCHAR2 (15)
Shipment Type Code
SHIP_TYPE_NAME VARCHAR2 (30)
Shipment Type Name
SHIP_NUM VARCHAR2 (25)
Shipment Number
SHIP_DATE DATE

Shipment Date
SHIP_STATUS_CODE VARCHAR2 (30)
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
PENDING_UPDATE_FLAG VARCHAR2 (1)
"Y" or "N" flag indicating the existence of lines updated but not processed by the landed cost calculation
SIMULATION_ID NUMBER

Simulation Identifier
SHIP_LINE_GROUP_ID NUMBER

Line Group Identifier
SHIP_LINE_GROUP_NUM NUMBER

Line Group Number
SHIP_LINE_GROUP_REFERENCE VARCHAR2 (30)
Line Group Reference
SRC_TYPE_CODE VARCHAR2 (30)
Source Type Code
GROUP_PARTY_ID NUMBER

Group Party Identifier
GROUP_PARTY_NAME VARCHAR2 (360)
GROUP_PARTY_SITE_ID NUMBER

Group Party Site Identifier
GROUP_PARTY_SITE_NAME VARCHAR2 (240)
Group Party Site Name
GROUP_ORGANIZATION_ID NUMBER

Group Organization Identifier
GROUP_ORGANIZATION_NAME VARCHAR2 (240)
SHIP_LINE_ID NUMBER

Shipment Line Identifier
SHIP_LINE_NUM NUMBER

Shipment Line Number
EST_SHIP_LINE_ID NUMBER

Estimated Shipment Line Identifier
EST_TXN_UNIT_PRICE NUMBER

Estimated Transaction Unit Price
SHIP_LINE_SRC_TYPE_CODE VARCHAR2 (30)
SHIP_LINE_SOURCE_ID NUMBER

Shipment Line Source Identifier
SHIP_LINE_TYPE_CODE VARCHAR2 (15)
LSO_SHIP_LINE_TYPE_NAME VARCHAR2 (30)
ITEM_ID NUMBER

Inventory Item Identifier
ITEM VARCHAR2 (40)
Item
ITEM_REVISION VARCHAR2 (3)
Item Revision
ITEM_DESCRIPTION VARCHAR2 (240)
Item Description
TXN_QTY NUMBER

Transaction Quantity
TXN_UOM_CODE VARCHAR2 (3)
Transaction Unit of Measure
PRIMARY_UOM_CODE VARCHAR2 (3)
Primary Unit of Measure Code
PRIMARY_QTY NUMBER

Primary Quantity
SECONDARY_UOM_CODE VARCHAR2 (3)
Secondary Unit of Measure
SECONDARY_QTY NUMBER

Secondary Quantity
TXN_UNIT_PRICE NUMBER

Transaction Unit Price
CURRENCY_CODE VARCHAR2 (15)
Currency Code
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
Currency Conversion Type
CURRENCY_CONVERSION_DATE DATE

Currency Conversion Date
CURRENCY_CONVERSION_RATE NUMBER

Currency Conversion Rate
LINE_AMT NUMBER

Line Amount
SRC_ID NUMBER

Source Identifier
SRC_TYPE VARCHAR2 (0)
Source Type
SRC_NUMBER VARCHAR2 (40)
Source Number
SRC_DESCRIPTION VARCHAR2 (0)
Source Description
SRC_ORG_ID NUMBER

Source Operating Unit Identifier
SRC_PARTY_ID NUMBER

Source Party Identifier
SRC_PARTY_NAME VARCHAR2 (360)
Source Party Name
SRC_PARTY_SITE_ID NUMBER

Source Party Site Identifier
SRC_PARTY_SITE_NAME VARCHAR2 (240)
Source Party Site Name
SRC_VENDOR_ID NUMBER

Source Vendor Identifier
SRC_VENDOR_NAME VARCHAR2 (0)
SRC_VENDOR_SITE_ID NUMBER

Source Vendor Site Identifier
SRC_VENDOR_SITE_CODE VARCHAR2 (0)
SRC_ORGANIZATION_ID NUMBER

Source Inventory Organization Identifier
SRC_LOCATION_ID NUMBER

Source Location Identifier
SRC_CUSTOMER_ID NUMBER

Source Customer Identifier
SRC_CUSTOMER_NAME VARCHAR2 (360)
Source Customer Name
SRC_CUSTOMER_NUMBER VARCHAR2 (30)
Source Customer Number
SRC_CUSTOMER_SITE_CODE VARCHAR2 (30)
ource Customer Site Code
SRC_CUST_ITEM_NUM VARCHAR2 (0)
Source Customer Item Number
SRC_RELEASE_NUM NUMBER

Source Release Number
SRC_RELEASE_ID NUMBER

Source Release Identifier
SRC_RELEASE_DATE DATE

Source Release Date
SRC_LINE_ID NUMBER

Source Line Identifier
SRC_LINE_NUM NUMBER

Source Line Number
SRC_SHIP_ID NUMBER

Source Shipment Identifier
SRC_SHIP_NUM VARCHAR2 (0)
Source Shipment Number
SRC_SHIPPED_DATE DATE

Source Shipped Date
SRC_QTY NUMBER

Source Quantity
SRC_ITEM_ID NUMBER

Source Inventory Item Identifier
SRC_ITEM_REVISION VARCHAR2 (3)
Source Item Revision
SRC_ITEM_DESCRIPTION VARCHAR2 (240)
Source Item Description
SRC_CONTAINER_NUM VARCHAR2 (35)
Source Container Number
SRC_TRUCK_NUM VARCHAR2 (35)
Source Truck Number
SRC_BAR_CODE_LABEL VARCHAR2 (35)
Source Bar Code Label
SRC_DELIVER_TO_PERSON_ID NUMBER

Source Deliver To Person Identifier
SRC_VENDOR_ITEM_NUM VARCHAR2 (25)
Source Vendor Item Number
SRC_PACKING_SLIP VARCHAR2 (25)
Source Packing Slip
SRC_EMPLOYEE_ID NUMBER

Source Employee Identifier
SRC_FREIGHT_CARRIER_CODE VARCHAR2 (25)
Source Freight Carrier Code
SRC_BILL_OF_LADING VARCHAR2 (25)
Source Bill Of Lading
SRC_ROUTING_ID NUMBER

Source Routing Identifier
SRC_INSPECTION_STATUS_CODE VARCHAR2 (25)
Source Inspection Status Code
SRC_TRANSACTION_DATE DATE

Source Transaction Date

[top of page]

APPS.INL_SHIP_RMA_OVERALL_V references the following:

APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
SYNONYM - HZ_CUST_ACCT_SITES
SYNONYM - HZ_CUST_SITE_USES
SYNONYM - HZ_PARTIES
SYNONYM - HZ_PARTY_SITES
SYNONYM - INL_SHIP_HEADERS
SYNONYM - INL_SHIP_LINES
SYNONYM - INL_SHIP_LINE_GROUPS
SYNONYM - OE_ORDER_HEADERS
SYNONYM - OE_ORDER_LINES
SYNONYM - RCV_SHIPMENT_HEADERS
SYNONYM - RCV_SHIPMENT_LINES
SYNONYM - RCV_SUPPLY
SYNONYM - RCV_TRANSACTIONS
- INL_ADJ_SHIP_LINES_V
- INL_SHIP_TYPES_VL
- OE_SOLD_TO_ORGS_V
- MTL_SYSTEM_ITEMS_VL
- INL_SHIP_LINE_TYPES_VL
- INL_SHIP_OVERALL_V

APPS.INL_SHIP_RMA_OVERALL_V is not referenced by any database object

[top of page]

View: INL_SHIP_TYPES_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

This view shows Shipment Type information in a given language.

Columns
Name Datatype Length Mandatory Comments
SHIP_TYPE_ID NUMBER
Y Shipment Type Identifier
SHIP_TYPE_CODE VARCHAR2 (15) Y Shipment Type Code
SHIP_TYPE_NAME VARCHAR2 (30) Y Shipment Type Name
TRD_PTIES_ALWD_CODE VARCHAR2 (1) Y Third Parties Allowed Code, taken from lookup INL_3RD_PARTIES_ALLOWED
ACTIVE_FROM_DATE DATE
Y Active From Date
ACTIVE_TO_DATE DATE

Active To Date
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y 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).
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

[top of page]

APPS.INL_SHIP_TYPES_VL references the following:

APPS
SYNONYM - INL_SHIP_TYPES_B
SYNONYM - INL_SHIP_TYPES_TL
APPS.INL_SHIP_TYPES_VL is referenced by following:

APPS
VIEW - INL_SHIP_OVERALL_V

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract