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_CHARGE_LINES
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_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_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_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_IR_SOURCE_LINES_V
VIEW - APPS.INL_PO_SOURCE_LINES_V
VIEW - APPS.INL_RMA_SOURCE_LINES_V
VIEW - APPS.INL_SHIPLN_LANDED_COSTS_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_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
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:

APPS
SYNONYM - INL_ALLOCATIONS
PACKAGE BODY - INL_INTERFACE_PVT

[top of page]

Table: INL_ALWD_LINE_TYPES

Description: This table stores Shipment Line Types that are allowed either for Shiment 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:

APPS
SYNONYM - 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:

APPS
SYNONYM - 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:

APPS
SYNONYM - 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:

APPS
SYNONYM - 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
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).

[top of page]

INL.INL_ASSOCIATIONS does not reference any database object

INL.INL_ASSOCIATIONS is referenced by following:

APPS
SYNONYM - INL_ASSOCIATIONS
PACKAGE BODY - INL_INTERFACE_PVT

[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
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
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_CHARGE_LINES does not reference any database object

INL.INL_CHARGE_LINES is referenced by following:

APPS
SYNONYM - INL_CHARGE_LINES
PACKAGE BODY - INL_INTERFACE_PVT

[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.

Columns
Name Datatype Length Mandatory Comments
INTERFACE_ERROR_ID NUMBER
Y Interface Error Identififer
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:

APPS
SYNONYM - INL_INTERFACE_ERRORS

[top of page]

Table: INL_MATCHES

Description: This table stores matches between actual and estimated amounts of a Landed Cost Shipment.
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
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).

[top of page]

INL.INL_MATCHES does not reference any database object

INL.INL_MATCHES is referenced by following:

APPS
SYNONYM - INL_MATCHES

[top of page]

Table: INL_MATCHES_INT

Description: This table stores Open Interface data for matches between actual and estimated amounts of a Landed Cost Shipment.
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
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

Match Amount Interface 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).
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).

[top of page]

INL.INL_MATCHES_INT does not reference any database object

INL.INL_MATCHES_INT is referenced by following:

APPS
SYNONYM - INL_MATCHES_INT

[top of page]

Table: INL_MATCH_AMOUNTS

Description: This table stores matches between actual and estimated charge amounts of a Landed Cost Shipment, grouped by Charge Line Type.
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

Match Amount 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).

[top of page]

INL.INL_MATCH_AMOUNTS does not reference any database object

INL.INL_MATCH_AMOUNTS is referenced by following:

APPS
SYNONYM - 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

This table stores Open Interface data for Match Amounts.

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 Match Amount 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
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
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]

INL.INL_MATCH_AMOUNTS_INT does not reference any database object

INL.INL_MATCH_AMOUNTS_INT is referenced by following:

APPS
SYNONYM - 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
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

[top of page]

INL.INL_PARAMETERS does not reference any database object

INL.INL_PARAMETERS is referenced by following:

APPS
SYNONYM - INL_PARAMETERS

[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
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) Y 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

[top of page]

INL.INL_SHIP_HEADERS_ALL does not reference any database object

INL.INL_SHIP_HEADERS_ALL is referenced by following:

APPS
PACKAGE BODY - INL_INTERFACE_PVT
SYNONYM - INL_SHIP_HEADERS
SYNONYM - 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
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
Y Shipment Date
SHIP_TYPE_ID NUMBER

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

Legal Entity Identifier
LEGAL_ENTITY_NAME VARCHAR2 (50)
Legal Entity Name
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

Organization identifier
TAXATION_COUNTRY VARCHAR2 (30) Y 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

[top of page]

INL.INL_SHIP_HEADERS_INT does not reference any database object

INL.INL_SHIP_HEADERS_INT is referenced by following:

APPS
SYNONYM - 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:

APPS
PACKAGE BODY - INL_INTERFACE_PVT
SYNONYM - 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
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
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 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
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

[top of page]

INL.INL_SHIP_LINES_ALL does not reference any database object

INL.INL_SHIP_LINES_ALL is referenced by following:

APPS
PACKAGE BODY - INL_INTERFACE_PVT
SYNONYM - INL_SHIP_LINES
SYNONYM - INL_SHIP_LINES_ALL

[top of page]

Table: INL_SHIP_LINES_INT

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

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

Indexes
Index Type Tablespace Column
INL_SHIP_LINES_INT_U1 UNIQUE APPS_TS_TX_IDX SHIP_LINE_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
Y Open Interface Group Identifier
PROCESSING_STATUS_CODE VARCHAR2 (25) Y Processing Status Code
VALIDATION_FLAG VARCHAR2 (1) Y "Y" or "N" flag indicating whether the record should be validated
SHIP_LINE_GROUP_REFERENCE VARCHAR2 (30)
Line Group Reference
PARTY_ID NUMBER

Party Identifier
PARTY_NUMBER VARCHAR2 (30)
Party Number
PARTY_SITE_ID NUMBER

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

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

Shipment Line Number
SHIP_LINE_TYPE_ID NUMBER

Shipment Line Type Identifier
SHIP_LINE_TYPE_CODE VARCHAR2 (15)
Shipment Line Type Code
SHIP_LINE_SRC_TYPE_CODE VARCHAR2 (30) Y 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) 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 Classifiction
TAX_CLASSIFICATION_CODE VARCHAR2 (30)
Tax Classification Code
ASSESSABLE_VALUE NUMBER

EBTAX Assessable Value
SHIP_FROM_PARTY_ID NUMBER

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

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

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

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

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

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

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

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

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

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

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

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

Shipment Identifier
SHIP_LINE_ID NUMBER

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

Source line identifier of the interface row
CREATED_BY NUMBER
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 defining column
ATTRIBUTE1_LG VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE2_LG VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE3_LG VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE4_LG VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE5_LG VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE6_LG VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE7_LG VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE8_LG VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE9_LG VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE10_LG VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE11_LG VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE12_LG VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE13_LG VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE14_LG VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE15_LG VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE_CATEGORY_SL VARCHAR2 (30)
Descriptive Flexfield structure defining column
ATTRIBUTE1_SL VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE2_SL VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE3_SL VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE4_SL VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE5_SL VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE6_SL VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE7_SL VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE8_SL VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE9_SL VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE10_SL VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE11_SL VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE12_SL VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE13_SL VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE14_SL VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE15_SL VARCHAR2 (150)
Descriptive Flexfield

[top of page]

INL.INL_SHIP_LINES_INT does not reference any database object

INL.INL_SHIP_LINES_INT is referenced by following:

APPS
SYNONYM - 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:

APPS
PACKAGE BODY - INL_INTERFACE_PVT
SYNONYM - 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:

APPS
SYNONYM - 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:

APPS
SYNONYM - 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:

APPS
SYNONYM - 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:

APPS
SYNONYM - INL_SHIP_TYPES_TL

[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_U2 UNIQUE APPS_TS_TX_IDX SHIP_HEADER_ID
TAX_LINE_NUM
SOURCE_PARENT_TABLE_NAME
SOURCE_PARENT_TABLE_ID
ADJUSTMENT_NUM
INL_TAX_LINES_N2 NONUNIQUE APPS_TS_TX_IDX SHIP_HEADER_ID
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
Y 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:

APPS
PACKAGE BODY - INL_INTERFACE_PVT
SYNONYM - INL_TAX_LINES

[top of page]

View: INL_ADJ_ASSOCIATIONS_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view shows adjusted associations between landed cost components of the same or different Shipments.

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

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

[top of page]

APPS.INL_ADJ_ASSOCIATIONS_V references the following:

APPS
VIEW - INL_ADJ_CHARGE_LINES_V
VIEW - INL_ADJ_SHIP_LINES_V
VIEW - INL_ADJ_TAX_LINES_V
SYNONYM - INL_ASSOCIATIONS
SYNONYM - INL_CHARGE_LINES
SYNONYM - INL_SHIP_LINES
SYNONYM - INL_TAX_LINES
APPS.INL_ADJ_ASSOCIATIONS_V is referenced by following:

APPS
PACKAGE BODY - INL_LANDEDCOST_PVT

[top of page]

View: INL_ADJ_CHARGE_LINES_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view shows adjusted information on Charge Lines.

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
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

[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_ADJ_ASSOCIATIONS_V
VIEW - INL_CHARGE_OVERALL_V
VIEW - INL_EBTAX_LINES_V
PACKAGE BODY - INL_LANDEDCOST_PVT
PACKAGE BODY - INL_SHIPMENT_PVT

[top of page]

View: INL_ADJ_SHIP_LINES_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view shows adjusted information on Shipment Lines.

Columns
Name Datatype Length Mandatory Comments
SHIP_HEADER_ID NUMBER
Y
SHIP_LINE_GROUP_ID NUMBER
Y
SHIP_LINE_ID NUMBER
Y
SHIP_LINE_NUM NUMBER
Y
SHIP_LINE_TYPE_ID NUMBER
Y
SHIP_LINE_SRC_TYPE_CODE VARCHAR2 (30)
SHIP_LINE_SOURCE_ID NUMBER

PARENT_SHIP_LINE_ID NUMBER

ADJUSTMENT_NUM NUMBER
Y
MATCH_ID NUMBER

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

CURRENCY_CONVERSION_RATE NUMBER

INVENTORY_ITEM_ID NUMBER

TXN_QTY NUMBER

TXN_UOM_CODE VARCHAR2 (3)
TXN_UNIT_PRICE NUMBER

PRIMARY_QTY NUMBER

PRIMARY_UOM_CODE VARCHAR2 (3)
PRIMARY_UNIT_PRICE NUMBER

FC_PRIMARY_UNIT_PRICE NUMBER

Functional primary unit price
SECONDARY_QTY NUMBER

SECONDARY_UOM_CODE VARCHAR2 (3)
SECONDARY_UNIT_PRICE NUMBER

LANDED_COST_FLAG VARCHAR2 (1) Y
ALLOCATION_ENABLED_FLAG VARCHAR2 (1) Y
TRX_BUSINESS_CATEGORY VARCHAR2 (240)
INTENDED_USE VARCHAR2 (30)
PRODUCT_FISCAL_CLASS VARCHAR2 (240)
PRODUCT_CATEGORY VARCHAR2 (240)
PRODUCT_TYPE VARCHAR2 (240)
USER_DEF_FISCAL_CLASS VARCHAR2 (240)
TAX_CLASSIFICATION_CODE VARCHAR2 (30)
ASSESSABLE_VALUE NUMBER

TAX_ALREADY_CALCULATED_FLAG VARCHAR2 (1)
SHIP_FROM_PARTY_ID NUMBER

SHIP_FROM_PARTY_SITE_ID NUMBER

SHIP_TO_ORGANIZATION_ID NUMBER

SHIP_TO_LOCATION_ID NUMBER

BILL_FROM_PARTY_ID NUMBER

BILL_FROM_PARTY_SITE_ID NUMBER

BILL_TO_ORGANIZATION_ID NUMBER

BILL_TO_LOCATION_ID NUMBER

POA_PARTY_ID NUMBER

POA_PARTY_SITE_ID NUMBER

POO_ORGANIZATION_ID NUMBER

POO_LOCATION_ID NUMBER

ORG_ID NUMBER
Y
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)

[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_ADJ_ASSOCIATIONS_V
VIEW - INL_EBTAX_LINES_V
PACKAGE BODY - INL_INTERFACE_PVT
PACKAGE BODY - INL_LANDEDCOST_PUB
PACKAGE BODY - INL_LANDEDCOST_PVT
PACKAGE BODY - INL_SHIPMENT_PVT
VIEW - INL_SHIP_OVERALL_V

[top of page]

View: INL_ADJ_TAX_LINES_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view shows adjusted information on Tax Lines.

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
Y 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 referenced by following:

APPS
VIEW - INL_ADJ_ASSOCIATIONS_V
PACKAGE BODY - INL_SHIPMENT_PVT

[top of page]

View: INL_ALLOCATIONS_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view shows all amounts of a Shipment, prorated into its Shipment Lines.

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.)

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
SYNONYM - MTL_UNITS_OF_MEASURE
APPS.INL_ALLOCATION_BASIS_VL is referenced by following:

APPS
PACKAGE BODY - INL_CHARGE_PVT
PACKAGE BODY - INL_SHIPMENT_PVT

[top of page]

View: INL_ALLOCATION_FLOW_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view shows information on the flow of the Shipment amounts to get the corresponding Shipment Lines.

Columns
Name Datatype Length Mandatory Comments
SHIP_HEADER_ID NUMBER

Shipment Identifier
ADJUSTMENT_NUM NUMBER

Adjustment Number
ASSOCIATION_ID NUMBER

Association Identifier
PARENT_TABLE_NAME VARCHAR2 (30)
Name of the table the amount comes from: INL_SHIP_HEADERS, INL_SHIP_LINE_GROUPS, INL_SHIP_LINES, INL_CHARGE_LINES, INL_TAX_LINES
PARENT_TABLE_ID NUMBER

Identifier of the table line the amount comes from: SHIP_HEADER_ID, SHIP_LINE_GROUP_ID, SHIP_LINE_ID, CHARGE_LINE_ID, TAX_LINE_ID
ALLOCATION_AMT NUMBER

Allocation Amount
ASSOC_FROM_PARENT_TABLE_NAME VARCHAR2 (30)
Name of the table the amount comes from: INL_SHIP_LINES, INL_CHARGE_LINES, INL_TAX_LINES
ASSOC_FROM_PARENT_TABLE_ID NUMBER

Identifier of the table line the amount comes from: SHIP_LINE_ID, CHARGE_LINE_ID, TAX_LINE_ID

[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
View Type

A public view which may be useful for custom reporting or other data requirements.

This view shows the summary of the allocation of Shipment amounts.

Columns
Name Datatype Length Mandatory Comments
SHIP_HEADER_ID NUMBER
Y Shipment Identifier
ADJUSTMENT_NUM NUMBER
Y Adjustment Number
ORGANIZATION_ID NUMBER
Y Inventory Organization Identifier
INVENTORY_ITEM_ID NUMBER

Inventory Item Identifier
PRIMARY_QTY NUMBER

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

Line Group Identifier
SHIP_LINE_ID NUMBER

Shipment Line Identifier
SHIP_LINE_NUM NUMBER

Shipment Line Number
ASSOCIATION_ID NUMBER

Association Identifier
ASSOC_FROM_PARENT_TABLE_NAME VARCHAR2 (30)
Name of the table the amount comes from: INL_SHIP_LINES, INL_CHARGE_LINES, INL_TAX_LINES
ASSOC_FROM_PARENT_TABLE_ID NUMBER

Identifier of the table line the amount comes from: SHIP_LINE_ID, CHARGE_LINE_ID, TAX_LINE_ID
CHARGE_LINE_ID NUMBER

Charge Line Identifier
TAX_LINE_ID NUMBER

Tax Line Identifier
ALLOCATION_ID NUMBER
Y Allocation Identifier
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

[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 referenced by following:

APPS
VIEW - INL_DET_LANDED_COSTS_V
VIEW - INL_SHIPLN_LANDED_COSTS_V

[top of page]

View: INL_CHARGE_LINE_TYPES_VL

Comments
View Type

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

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 CHAR (11)
Active From Date
ACTIVE_TO_DATE VARCHAR2 (11)
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:

APPS
VIEW - PON_COST_FACTORS_VL
APPS.INL_CHARGE_LINE_TYPES_VL is referenced by following:

APPS
PACKAGE BODY - INL_CHARGE_PVT
VIEW - INL_DET_LANDED_COSTS_V
PACKAGE BODY - INL_SHIPMENT_PVT

[top of page]

View: INL_CHARGE_OVERALL_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view shows overall information on Charges.

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 Organization 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
View Type

A public view which may be useful for custom reporting or other data requirements.

This view shows corrected information of matches between actual and estimated amounts of a Landed Cost Shipment.

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, INL_CHARGE_LINES.
TO_PARENT_TABLE_ID NUMBER

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

Matched Quantity
MATCHED_UOM_CODE VARCHAR2 (3)
Matched Unit of Measure Code
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)
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" 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 referenced by following:

APPS
VIEW - INL_CORR_MATCH_AMOUNTS_V
PACKAGE BODY - INL_INTERFACE_PVT
PACKAGE BODY - INL_SHIPMENT_PVT

[top of page]

View: INL_CORR_MATCH_AMOUNTS_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view shows matches between actual and estimated charge amounts of a Landed Cost Shipment, grouped by Charge Line Type.

Columns
Name Datatype Length Mandatory Comments
MATCH_AMOUNT_ID NUMBER
Y Match Amount Identifier
MATCHED_AMT NUMBER

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
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_MATCH_AMOUNTS_V references the following:

APPS
VIEW - INL_CORR_MATCHES_V
PACKAGE - INL_LANDEDCOST_PVT
SYNONYM - INL_MATCH_AMOUNTS
APPS.INL_CORR_MATCH_AMOUNTS_V is referenced by following:

APPS
PACKAGE BODY - INL_SHIPMENT_PVT

[top of page]

View: INL_DET_LANDED_COSTS_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view shows detailed landed cost information for a Shipment.

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

Line Group Identifier
SHIP_LINE_ID NUMBER

Shipment Line Identifier
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
ALLOCATED_AMT NUMBER

Allocation Amount
ALLOCATION_PERCENT NUMBER

Percentual of Allocation
COMPONENT_TYPE VARCHAR2 (10)
Component Type
COMPONENT_NAME VARCHAR2 (80)
Component Name

[top of page]

APPS.INL_DET_LANDED_COSTS_V references the following:

APPS
VIEW - INL_ALLOCATION_SUMMARY_V
SYNONYM - INL_CHARGE_LINES
VIEW - INL_CHARGE_LINE_TYPES_VL
VIEW - INL_SHIP_LANDED_COSTS_V
SYNONYM - INL_TAX_LINES
VIEW - MTL_SYSTEM_ITEMS_VL
VIEW - MTL_UNITS_OF_MEASURE_VL

APPS.INL_DET_LANDED_COSTS_V is not referenced by any database object

[top of page]

View: INL_EBTAX_LINES_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view shows EBTAX Line information.

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:

APPS
VIEW - INL_ADJ_CHARGE_LINES_V
VIEW - INL_ADJ_SHIP_LINES_V
APPS.INL_EBTAX_LINES_V is referenced by following:

APPS
PACKAGE - INL_TAX_PVT
PACKAGE BODY - INL_TAX_PVT

[top of page]

View: INL_ENTER_RECEIPTS_PO_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

A supplementary view used to simplify UI coding (Cloned from RCV_ENTER_RECEIPTS_PO_V).

Columns
Name Datatype Length Mandatory Comments
LINE_CHKBOX CHAR (1)
Line Checkbox
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 Shipment 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

Receiving Shipment Header Identifier
RCV_SHIPMENT_NUMBER VARCHAR2 (0)
Receiving Shipment Number
RCV_SHIPMENT_LINE_ID NUMBER

Receiving Shipment Line Identifier
RCV_LINE_NUMBER NUMBER

Receiving Line Number
FROM_ORGANIZATION_ID NUMBER
Y From Organization Identifier
TO_ORGANIZATION_ID NUMBER

Destination Inventory Organization Identifier
VENDOR_ID NUMBER

Vendor Identifier
SOURCE VARCHAR2 (240)
Source
VENDOR_SITE_ID NUMBER

Vendor Site Identifier
OUTSIDE_OPERATION_FLAG VARCHAR2 (1)
Outside Operation Flag
ITEM_ID NUMBER

Inventory Item Identifier
PRIMARY_UOM VARCHAR2 (25)
Primary Unit of Measure
PRIMARY_UOM_CLASS VARCHAR2 (10)
Primary Unit of Measure Class
ITEM_ALLOWED_UNITS_LOOKUP_CODE NUMBER

Inventory Item Allowed Units
ITEM_LOCATOR_CONTROL NUMBER

Inventory Item Locator Control
RESTRICT_LOCATORS_CODE VARCHAR2 (1)
Restrict Locators Code
RESTRICT_SUBINVENTORIES_CODE VARCHAR2 (1)
Restrict Subinventories Code
SHELF_LIFE_CODE NUMBER

Shelf Life Code
SHELF_LIFE_DAYS NUMBER

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)
Inventory Item Revision Control Flag To
ITEM_REV_CONTROL_FLAG_FROM VARCHAR2 (0)
Inventory Item Revision Control Flag From
ITEM_NUMBER VARCHAR2 (0)
Inventory Item Number
ITEM_REVISION VARCHAR2 (3)
Inventory Item Revision
ITEM_DESCRIPTION VARCHAR2 (240)
Inventory Item Description
ITEM_CATEGORY_ID NUMBER

Inventory Item Category Identifier
HAZARD_CLASS VARCHAR2 (40)
Hazard Class
UN_NUMBER VARCHAR2 (25)
UN 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

Routing Identifier
ROUTING_NAME VARCHAR2 (80)
Routing Name
NEED_BY_DATE DATE

Need By Date
EXPECTED_RECEIPT_DATE DATE

Expecte Arrival Date
ORDERED_QTY NUMBER

Ordered Quantity
ORDERED_UOM VARCHAR2 (25)
Ordered Unit of Measure
USSGL_TRANSACTION_CODE VARCHAR2 (0)
USSGL Transaction Code
GOVERNMENT_CONTEXT VARCHAR2 (30)
Government Context
INSPECTION_REQUIRED_FLAG VARCHAR2 (1)
Inspection Required Flag
RECEIPT_REQUIRED_FLAG VARCHAR2 (1)
Receipt Required Flag
ENFORCE_SHIP_TO_LOCATION_CODE VARCHAR2 (25)
Enforce Ship to Location Code
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)
Note to Receiver
DESTINATION_TYPE_CODE VARCHAR2 (0)
Destination Type
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)
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
CLOSED_CODE VARCHAR2 (30)
Closed Code
ASN_TYPE VARCHAR2 (0)
ASN Type
BILL_OF_LADING VARCHAR2 (0)
Bill Of Lading Number
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)
Rate Type Display
MATCH_OPTION VARCHAR2 (25)
Match Option
COUNTRY_OF_ORIGIN_CODE VARCHAR2 (2)
Country of Origin
OE_ORDER_HEADER_ID NUMBER

OE Order Header Identifier
OE_ORDER_NUM NUMBER

OE Order Number
OE_ORDER_LINE_ID NUMBER

OE Order Line Identifier
OE_ORDER_LINE_NUM NUMBER

OE 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)
PO Shipment Note to Receiver
SECONDARY_ORDERED_QTY NUMBER

Ordered Quantity in Secondary unit of measure
SECONDARY_ORDERED_UOM VARCHAR2 (25)
Ordered items secondary unit of measure
QC_GRADE VARCHAR2 (150)
QC Grade
LPN_ID NUMBER

LPN Identifier
SECONDARY_DEFAULT_IND VARCHAR2 (30)
Secondary Default
ORG_ID NUMBER

Operating Unit Identifier
OE_ORDER_SHIP_NUM NUMBER

OE Order Shipment Number
LCM_SHIPMENT_LINE_ID NUMBER

Shipment Line Identifier
UNIT_LANDED_COST NUMBER

Unit Landed Cost
LCM_SHIPMENT_FLAG VARCHAR2 (1)
"Y" or "N" flag indicating whether a given Shipment is enabled for LCM

[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 - MTL_UNITS_OF_MEASURE
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
VIEW - RCV_ROUTING_HEADERS
APPS.INL_ENTER_RECEIPTS_PO_V is referenced by following:

APPS
VIEW - INL_ENTER_RECEIPTS_V
PACKAGE BODY - INL_SHIPMENT_PVT

[top of page]

View: INL_ENTER_RECEIPTS_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

A supplementary view used to simplify UI coding (Cloned from RCV_ENTER_RECEIPTS_V).

Columns
Name Datatype Length Mandatory Comments
LINE_CHKBOX CHAR (1)
Line Checkbox
SOURCE_TYPE_CODE VARCHAR2 (8)
Source Type Code
RECEIPT_SOURCE_CODE VARCHAR2 (25)
Receipt Source Code
ORDER_TYPE_CODE VARCHAR2 (30)
Order Type Code
ORDER_TYPE VARCHAR2 (30)
Order Type
PO_HEADER_ID NUMBER

PO Header Identifier
PO_NUMBER VARCHAR2 (20)
PO Number
PO_LINE_ID NUMBER

PO Line Identifier
PO_LINE_NUMBER NUMBER

PO Line Number
PO_LINE_LOCATION_ID NUMBER

PO Shipment 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 (20)
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

Receiving Shipment Header Identifier
RCV_SHIPMENT_NUMBER VARCHAR2 (30)
Receiving Shipment Number
RCV_SHIPMENT_LINE_ID NUMBER

Receiving Shipment Line Identifier
RCV_LINE_NUMBER NUMBER

Receiving Line Number
FROM_ORGANIZATION_ID NUMBER

From Organization Identifier
TO_ORGANIZATION_ID NUMBER

Destination Inventory Organization Identifier
VENDOR_ID NUMBER

Vendor Identifier
SOURCE VARCHAR2 (360)
Source
VENDOR_SITE_ID NUMBER

Vendor Site Identifier
OUTSIDE_OPERATION_FLAG VARCHAR2 (1)
Outside Operation Flag
ITEM_ID NUMBER

Inventory Item Identifier
PRIMARY_UOM VARCHAR2 (25)
Primary Unit of Measure
PRIMARY_UOM_CLASS VARCHAR2 (10)
Primary Unit of Measure Class
ITEM_ALLOWED_UNITS_LOOKUP_CODE NUMBER

Inventory Item Allowed Units
ITEM_LOCATOR_CONTROL NUMBER

Inventory Item Locator Control
RESTRICT_LOCATORS_CODE VARCHAR2 (1)
Restrict Locators Code
RESTRICT_SUBINVENTORIES_CODE VARCHAR2 (1)
Restrict Subinventories Code
SHELF_LIFE_CODE NUMBER

Shelf Life Code
SHELF_LIFE_DAYS NUMBER

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)
Inventory Item Revision Control Flag To
ITEM_REV_CONTROL_FLAG_FROM VARCHAR2 (1)
Inventory Item Revision Control Flag From
ITEM_NUMBER VARCHAR2 (40)
Inventory Item Number
ITEM_REVISION VARCHAR2 (3)
Inventory Item Revision
ITEM_DESCRIPTION VARCHAR2 (240)
Inventory Item Description
ITEM_CATEGORY_ID NUMBER

Inventory Item Category Identifier
HAZARD_CLASS VARCHAR2 (40)
Hazard Class
UN_NUMBER VARCHAR2 (25)
UN 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 Identifier
PACKING_SLIP VARCHAR2 (25)
Packing Slip
ROUTING_ID NUMBER

Routing Identifier
ROUTING_NAME VARCHAR2 (80)
Routing Name
NEED_BY_DATE DATE

Need By Date
EXPECTED_RECEIPT_DATE DATE

Expecte Arrival Date
ORDERED_QTY NUMBER

Ordered Quantity
ORDERED_UOM VARCHAR2 (25)
Ordered Unit of Measure
USSGL_TRANSACTION_CODE VARCHAR2 (30)
USSGL Transaction Code
GOVERNMENT_CONTEXT VARCHAR2 (30)
Government Context
INSPECTION_REQUIRED_FLAG VARCHAR2 (1)
Inspection Required Flag
RECEIPT_REQUIRED_FLAG VARCHAR2 (1)
Receipt Required Flag
ENFORCE_SHIP_TO_LOCATION_CODE VARCHAR2 (25)
Enforce Ship to Location Code
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)
Note to Receiver
DESTINATION_TYPE_CODE VARCHAR2 (25)
Destination Type
DELIVER_TO_PERSON_ID NUMBER

Deliver to Person Identifier
DELIVER_TO_LOCATION_ID NUMBER

Deliver to Location Identifier
DESTINATION_SUBINVENTORY VARCHAR2 (10)
Destination Subinventory
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (240)
Descriptive flexfield segment
CLOSED_CODE VARCHAR2 (30)
Closed Code
ASN_TYPE VARCHAR2 (25)
ASN Type
BILL_OF_LADING VARCHAR2 (25)
Bill Of Lading Number
SHIPPED_DATE DATE

Shipped Date
FREIGHT_CARRIER_CODE VARCHAR2 (25)
Freight Carrier Code
WAYBILL_AIRBILL_NUM VARCHAR2 (20)
Waybill/Airbill Number
FREIGHT_BILL_NUM VARCHAR2 (35)
Freight Bill Number
VENDOR_LOT_NUM VARCHAR2 (30)
Vendor Lot Number
CONTAINER_NUM VARCHAR2 (35)
Container Number
TRUCK_NUM VARCHAR2 (35)
Truck Number
BAR_CODE_LABEL VARCHAR2 (35)
Bar Code Label
RATE_TYPE_DISPLAY VARCHAR2 (30)
Rate Type Display
MATCH_OPTION VARCHAR2 (25)
Match Option
COUNTRY_OF_ORIGIN_CODE VARCHAR2 (2)
Country of Origin
OE_ORDER_HEADER_ID NUMBER

OE Order Header Identifier
OE_ORDER_NUM NUMBER

OE Order Number
OE_ORDER_LINE_ID NUMBER

OE Order Line Identifier
OE_ORDER_LINE_NUM NUMBER

OE Order Line Number
CUSTOMER_ID NUMBER

Customer Identifier
CUSTOMER_SITE_ID NUMBER

Customer Site Identifier
CUSTOMER_ITEM_NUM VARCHAR2 (50)
Customer Item Number
PLL_NOTE_TO_RECEIVER VARCHAR2 (2000)
PO Shipment Note to Receiver
SECONDARY_ORDERED_QTY NUMBER

Ordered Quantity in Secondary unit of measure
SECONDARY_ORDERED_UOM VARCHAR2 (25)
Ordered items secondary unit of measure
QC_GRADE VARCHAR2 (150)
QC Grade
LPN_ID NUMBER

LPN Identifier
SECONDARY_DEFAULT_IND VARCHAR2 (30)
Secondary Default
ORG_ID NUMBER

Organization identifier
OE_ORDER_SHIP_NUM NUMBER

OE Order Shipment Number
LCM_SHIPMENT_LINE_ID NUMBER

Shipment Line Identifier
UNIT_LANDED_COST NUMBER

Unit Landed Cost
LCM_SHIPMENT_FLAG VARCHAR2 (1)
"Y" or "N" flag indicating whether a given Shipment is enabled for LCM

[top of page]

APPS.INL_ENTER_RECEIPTS_V references the following:

APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
VIEW - INL_ENTER_RECEIPTS_PO_V
PACKAGE - OE_SYS_PARAMETERS
VIEW - RCV_ENTER_RECEIPTS_ASN_V
VIEW - RCV_ENTER_RECEIPTS_INT_REQ_V
VIEW - RCV_ENTER_RECEIPTS_INVENTORY_V
VIEW - RCV_ENTER_RECEIPTS_RMA_V
APPS.INL_ENTER_RECEIPTS_V is referenced by following:

APPS
VIEW - INL_IR_SOURCE_LINES_V
VIEW - INL_PO_SOURCE_LINES_V
VIEW - INL_RMA_SOURCE_LINES_V

[top of page]

View: INL_IR_SOURCE_LINES_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view shows expected receipts from Internal Requisition.

Columns
Name Datatype Length Mandatory Comments
LINE_CHKBOX CHAR (1)
Line Checkbox
SOURCE_TYPE_CODE VARCHAR2 (8)
Source Type Code
RECEIPT_SOURCE_CODE VARCHAR2 (25)
Receipt Source Code
ORDER_TYPE_CODE VARCHAR2 (30)
Order Type Code
ORDER_TYPE VARCHAR2 (30)
Order Type
PO_HEADER_ID NUMBER

PO Header Identifier
PO_NUMBER VARCHAR2 (20)
PO Number
PO_LINE_ID NUMBER

PO Line Identifier
PO_LINE_NUMBER NUMBER

PO Line Number
PO_LINE_LOCATION_ID NUMBER

PO Shipment 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 (20)
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

Receiving Shipment Header Identifier
RCV_SHIPMENT_NUMBER VARCHAR2 (30)
Receiving Shipment Number
RCV_SHIPMENT_LINE_ID NUMBER

Receiving Shipment Line Identifier
RCV_LINE_NUMBER NUMBER

Receiving Line Number
FROM_ORGANIZATION_ID NUMBER

From Organization Identifier
TO_ORGANIZATION_ID NUMBER

Destination Inventory Organization Identifier
VENDOR_ID NUMBER

Vendor Identifier
SOURCE VARCHAR2 (360)
Source
VENDOR_SITE_ID NUMBER

Vendor Site Identifier
OUTSIDE_OPERATION_FLAG VARCHAR2 (1)
Outside Operation Flag
ITEM_ID NUMBER

Inventory Item Identifier
PRIMARY_UOM VARCHAR2 (25)
Primary Unit of Measure
PRIMARY_UOM_CLASS VARCHAR2 (10)
Primary Unit of Measure Class
ITEM_ALLOWED_UNITS_CODE NUMBER

Inventory Item Allowed Units
ITEM_LOCATOR_CONTROL NUMBER

Inventory Item Locator Control
RESTRICT_LOCATORS_CODE VARCHAR2 (1)
Restrict Locators Code
RESTRICT_SUBINVENTORIES_CODE VARCHAR2 (1)
Restrict Subinventories Code
SHELF_LIFE_CODE NUMBER

Shelf Life Code
SHELF_LIFE_DAYS NUMBER

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)
Inventory Item Revision Control Flag To
ITEM_REV_CONTROL_FLAG_FROM VARCHAR2 (1)
Inventory Item Revision Control Flag From
ITEM_NUMBER VARCHAR2 (40)
Inventory Item Number
ITEM_REVISION VARCHAR2 (3)
Inventory Item Revision
ITEM_DESCRIPTION VARCHAR2 (240)
Inventory Item Description
ITEM_CATEGORY_ID NUMBER

Inventory Item Category Identifier
HAZARD_CLASS VARCHAR2 (40)
Hazard Class
UN_NUMBER VARCHAR2 (25)
UN 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 Identifier
PACKING_SLIP VARCHAR2 (25)
Packing Slip
ROUTING_ID NUMBER

Routing Identifier
ROUTING_NAME VARCHAR2 (80)
Routing Name
NEED_BY_DATE DATE

Need By Date
EXPECTED_RECEIPT_DATE DATE

Expected Arrival Date
ORDERED_QTY NUMBER

Ordered Quantity
ORDERED_UOM VARCHAR2 (25)
Ordered Unit of Measure
USSGL_TRANSACTION_CODE VARCHAR2 (30)
USSGL Transaction Code
GOVERNMENT_CONTEXT VARCHAR2 (30)
Government Context
INSPECTION_REQUIRED_FLAG VARCHAR2 (1)
Inspection Required Flag
RECEIPT_REQUIRED_FLAG VARCHAR2 (1)
Receipt Required Flag
ENFORCE_SHIP_TO_LOCATION_CODE VARCHAR2 (25)
Enforce Ship to Location Code
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)
Note to Receiver
DESTINATION_TYPE_CODE VARCHAR2 (25)
Destination Type
DELIVER_TO_PERSON_ID NUMBER

Deliver to Person Identifier
DELIVER_TO_LOCATION_ID NUMBER

Deliver to Location Identifier
DESTINATION_SUBINVENTORY VARCHAR2 (10)
Destination Subinventory
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (240)
Descriptive flexfield segment
CLOSED_CODE VARCHAR2 (30)
Closed Code
ASN_TYPE VARCHAR2 (25)
ASN Type
BILL_OF_LADING VARCHAR2 (25)
Bill of Lading
SHIPPED_DATE DATE

Shipped Date
FREIGHT_CARRIER_CODE VARCHAR2 (25)
Freight Carrier Code
WAYBILL_AIRBILL_NUM VARCHAR2 (20)
Waybill/Airbill Number
FREIGHT_BILL_NUM VARCHAR2 (35)
Freight Bill Number
VENDOR_LOT_NUM VARCHAR2 (30)
Vendor Lot Number
CONTAINER_NUM VARCHAR2 (35)
Container Number
TRUCK_NUM VARCHAR2 (35)
Truck Number
BAR_CODE_LABEL VARCHAR2 (35)
Bar Code Label
RATE_TYPE_DISPLAY VARCHAR2 (30)
Rate Type Display
MATCH_OPTION VARCHAR2 (25)
Match Option
COUNTRY_OF_ORIGIN_CODE VARCHAR2 (2)
Country of Origin
OE_ORDER_HEADER_ID NUMBER

OE Order Header Identifier
OE_ORDER_NUM NUMBER

OE Order Number
OE_ORDER_LINE_ID NUMBER

OE Order Line Identifier
OE_ORDER_LINE_NUM NUMBER

OE Order Line Number
CUSTOMER_ID NUMBER

Customer Identifier
CUSTOMER_SITE_ID NUMBER

Customer Site Identifier
CUSTOMER_ITEM_NUM VARCHAR2 (50)
Customer Item Number
PLL_NOTE_TO_RECEIVER VARCHAR2 (2000)
PO Shipment Note to Receiver
SECONDARY_ORDERED_QTY NUMBER

Secondary Ordered Quantity
SECONDARY_ORDERED_UOM VARCHAR2 (25)
Secondary Ordered Unit of Measure
QC_GRADE VARCHAR2 (150)
QC Grade
LPN_ID NUMBER

LPN Identifier
SECONDARY_DEFAULT_IND VARCHAR2 (30)
Secondary Default
ORG_ID NUMBER

Organization identifier
OE_ORDER_SHIP_NUM NUMBER

OE Order Shipment Number

[top of page]

APPS.INL_IR_SOURCE_LINES_V references the following:

APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
VIEW - INL_ENTER_RECEIPTS_V
PACKAGE - OE_SYS_PARAMETERS

APPS.INL_IR_SOURCE_LINES_V is not referenced by any database object

[top of page]

View: INL_PO_SOURCE_LINES_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view shows expected receipts from Purchase Orders.

Columns
Name Datatype Length Mandatory Comments
LINE_CHKBOX CHAR (1)
Line Checkbox
SOURCE_TYPE_CODE VARCHAR2 (8)
Source Type Code
RECEIPT_SOURCE_CODE VARCHAR2 (25)
Receipt Source Code
ORDER_TYPE_CODE VARCHAR2 (30)
Order Type Code
ORDER_TYPE VARCHAR2 (30)
Order Type
PO_HEADER_ID NUMBER

PO Header Identifier
PO_NUMBER VARCHAR2 (20)
PO Number
PO_LINE_ID NUMBER

PO Line Identifier
PO_LINE_NUMBER NUMBER

PO Line Number
PO_LINE_LOCATION_ID NUMBER

PO Shipment 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 (20)
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

Receiving Shipment Header Identifier
RCV_SHIPMENT_NUMBER VARCHAR2 (30)
Receiving Shipment Number
RCV_SHIPMENT_LINE_ID NUMBER

Receiving Shipment Line Identifier
RCV_LINE_NUMBER NUMBER

Receiving Line Number
FROM_ORGANIZATION_ID NUMBER

From Organization Identifier
TO_ORGANIZATION_ID NUMBER

Destination Inventory Organization Identifier
VENDOR_ID NUMBER

Vendor Identifier
SOURCE VARCHAR2 (360)
Source
VENDOR_SITE_ID NUMBER

Vendor Site Identifier
OUTSIDE_OPERATION_FLAG VARCHAR2 (1)
Outside Operation Flag
ITEM_ID NUMBER

Inventory Item Identifier
PRIMARY_UOM VARCHAR2 (25)
Primary Unit of Measure
PRIMARY_UOM_CLASS VARCHAR2 (10)
Primary Unit of Measure Class
ITEM_ALLOWED_UNITS_CODE NUMBER

Inventory Item Allowed Units
ITEM_LOCATOR_CONTROL NUMBER

Inventory Item Locator Control
RESTRICT_LOCATORS_CODE VARCHAR2 (1)
Restrict Locators Code
RESTRICT_SUBINVENTORIES_CODE VARCHAR2 (1)
Restrict Subinventories Code
SHELF_LIFE_CODE NUMBER

Shelf Life Code
SHELF_LIFE_DAYS NUMBER

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)
Inventory Item Revision Control Flag To
ITEM_REV_CONTROL_FLAG_FROM VARCHAR2 (1)
Inventory Item Revision Control Flag From
ITEM_NUMBER VARCHAR2 (40)
Inventory Item Number
ITEM_REVISION VARCHAR2 (3)
Inventory Item Revision
ITEM_DESCRIPTION VARCHAR2 (240)
Inventory Item Description
ITEM_CATEGORY_ID NUMBER

Inventory Item Category Identifier
HAZARD_CLASS VARCHAR2 (40)
Hazard Class
UN_NUMBER VARCHAR2 (25)
UN 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 Identifier
PACKING_SLIP VARCHAR2 (25)
Packing Slip
ROUTING_ID NUMBER

Routing Identifier
ROUTING_NAME VARCHAR2 (80)
Routing Name
NEED_BY_DATE DATE

Need By Date
EXPECTED_RECEIPT_DATE DATE

Expecte Arrival Date
ORDERED_QTY NUMBER

Ordered Quantity
ORDERED_UOM VARCHAR2 (25)
Ordered Unit of Measure
USSGL_TRANSACTION_CODE VARCHAR2 (30)
USSGL Transaction Code
GOVERNMENT_CONTEXT VARCHAR2 (30)
Government Context
INSPECTION_REQUIRED_FLAG VARCHAR2 (1)
Inspection Required Flag
RECEIPT_REQUIRED_FLAG VARCHAR2 (1)
Receipt Required Flag
ENFORCE_SHIP_TO_LOCATION_CODE VARCHAR2 (25)
Enforce Ship to Location Code
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)
Note to Receiver
DESTINATION_TYPE_CODE VARCHAR2 (25)
Destination Type
DELIVER_TO_PERSON_ID NUMBER

Deliver to Person Identifier
DELIVER_TO_LOCATION_ID NUMBER

Deliver to Location Identifier
DESTINATION_SUBINVENTORY VARCHAR2 (10)
Destination Subinventory
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (240)
Descriptive flexfield segment
CLOSED_CODE VARCHAR2 (30)
Closed Code
ASN_TYPE VARCHAR2 (25)
ASN Type
BILL_OF_LADING VARCHAR2 (25)
Bill of Lading
SHIPPED_DATE DATE

Shipped Date
FREIGHT_CARRIER_CODE VARCHAR2 (25)
Freight Carrier Code
WAYBILL_AIRBILL_NUM VARCHAR2 (20)
Waybill/Airbill Number
FREIGHT_BILL_NUM VARCHAR2 (35)
Freight Bill Number
VENDOR_LOT_NUM VARCHAR2 (30)
Vendor Lot Number
CONTAINER_NUM VARCHAR2 (35)
Container Number
TRUCK_NUM VARCHAR2 (35)
Truck Number
BAR_CODE_LABEL VARCHAR2 (35)
Bar Code Label
RATE_TYPE_DISPLAY VARCHAR2 (30)
Rate Type Display
MATCH_OPTION VARCHAR2 (25)
Match Option
COUNTRY_OF_ORIGIN_CODE VARCHAR2 (2)
Country of Origin
OE_ORDER_HEADER_ID NUMBER

OE Order Header Identifier
OE_ORDER_NUM NUMBER

OE Order Number
OE_ORDER_LINE_ID NUMBER

OE Order Line Identifier
OE_ORDER_LINE_NUM NUMBER

OE Order Line Number
CUSTOMER_ID NUMBER

Customer Identifier
CUSTOMER_SITE_ID NUMBER

Customer Site Identifier
CUSTOMER_ITEM_NUM VARCHAR2 (50)
Customer Item Number
PLL_NOTE_TO_RECEIVER VARCHAR2 (2000)
PO Shipment Note to Receiver
SECONDARY_ORDERED_QTY NUMBER

Secondary Ordered Quantity
SECONDARY_ORDERED_UOM VARCHAR2 (25)
Secondary Ordered Unit of Measure
QC_GRADE VARCHAR2 (150)
QC Grade
LPN_ID NUMBER

LPN Identifier
SECONDARY_DEFAULT_IND VARCHAR2 (30)
Secondary Default
ORG_ID NUMBER

Organization identifier
OE_ORDER_SHIP_NUM NUMBER

OE Order Shipment Number
PARTY_ID NUMBER

Party Identifier
PARTY_SITE_ID NUMBER (15)
Party Site Identifier

[top of page]

APPS.INL_PO_SOURCE_LINES_V references the following:

APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
VIEW - INL_ENTER_RECEIPTS_V
PACKAGE - OE_SYS_PARAMETERS
VIEW - PO_VENDORS
VIEW - PO_VENDOR_SITES_ALL

APPS.INL_PO_SOURCE_LINES_V is not referenced by any database object

[top of page]

View: INL_RMA_SOURCE_LINES_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view shows expected receipts from Return Material Authorizations.

Columns
Name Datatype Length Mandatory Comments
LINE_CHKBOX CHAR (1)
Line Checkbox
SOURCE_TYPE_CODE VARCHAR2 (8)
Source Type Code
RECEIPT_SOURCE_CODE VARCHAR2 (25)
Receipt Source Code
ORDER_TYPE_CODE VARCHAR2 (30)
Order Type Code
ORDER_TYPE VARCHAR2 (30)
Order Type
PO_HEADER_ID NUMBER

PO Header Identifier
PO_NUMBER VARCHAR2 (20)
PO Number
PO_LINE_ID NUMBER

PO Line Identifier
PO_LINE_NUMBER NUMBER

PO Line Number
PO_LINE_LOCATION_ID NUMBER

PO Shipment 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 (20)
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

Receiving Shipment Header Identifier
RCV_SHIPMENT_NUMBER VARCHAR2 (30)
Receiving Shipment Number
RCV_SHIPMENT_LINE_ID NUMBER

Receiving Shipment Line Identifier
RCV_LINE_NUMBER NUMBER

Receiving Line Number
FROM_ORGANIZATION_ID NUMBER

From Organization Identifier
TO_ORGANIZATION_ID NUMBER

Destination Inventory Organization Identifier
VENDOR_ID NUMBER

Vendor Identifier
SOURCE VARCHAR2 (360)
Source
VENDOR_SITE_ID NUMBER

Vendor Site Identifier
OUTSIDE_OPERATION_FLAG VARCHAR2 (1)
Outside Operation Flag
ITEM_ID NUMBER

Inventory Item Identifier
PRIMARY_UOM VARCHAR2 (25)
Primary Unit of Measure
PRIMARY_UOM_CLASS VARCHAR2 (10)
Primary Unit of Measure Class
ITEM_ALLOWED_UNITS_CODE NUMBER

Inventory Item Allowed Units
ITEM_LOCATOR_CONTROL NUMBER

Inventory Item Locator Control
RESTRICT_LOCATORS_CODE VARCHAR2 (1)
Restrict Locators Code
RESTRICT_SUBINVENTORIES_CODE VARCHAR2 (1)
Restrict Subinventories Code
SHELF_LIFE_CODE NUMBER

Shelf Life Code
SHELF_LIFE_DAYS NUMBER

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)
Inventory Item Revision Control Flag To
ITEM_REV_CONTROL_FLAG_FROM VARCHAR2 (1)
Inventory Item Revision Control Flag From
ITEM_NUMBER VARCHAR2 (40)
Inventory Item Number
ITEM_REVISION VARCHAR2 (3)
Inventory Item Revision
ITEM_DESCRIPTION VARCHAR2 (240)
Inventory Item Description
ITEM_CATEGORY_ID NUMBER

Inventory Item Category Identifier
HAZARD_CLASS VARCHAR2 (40)
Hazard Class
UN_NUMBER VARCHAR2 (25)
UN 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 Identifier
PACKING_SLIP VARCHAR2 (25)
Packing Slip
ROUTING_ID NUMBER

Routing Identifier
ROUTING_NAME VARCHAR2 (80)
Routing Name
NEED_BY_DATE DATE

Need By Date
EXPECTED_RECEIPT_DATE DATE

Expecte Arrival Date
ORDERED_QTY NUMBER

Ordered Quantity
ORDERED_UOM VARCHAR2 (25)
Ordered Unit of Measure
USSGL_TRANSACTION_CODE VARCHAR2 (30)
USSGL Transaction Code
GOVERNMENT_CONTEXT VARCHAR2 (30)
Government Context
INSPECTION_REQUIRED_FLAG VARCHAR2 (1)
Inspection Required Flag
RECEIPT_REQUIRED_FLAG VARCHAR2 (1)
Receipt Required Flag
ENFORCE_SHIP_TO_LOCATION_CODE VARCHAR2 (25)
Enforce Ship to Location Code
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)
Note to Receiver
DESTINATION_TYPE_CODE VARCHAR2 (25)
Destination Type
DELIVER_TO_PERSON_ID NUMBER

Deliver to Person Identifier
DELIVER_TO_LOCATION_ID NUMBER

Deliver to Location Identifier
DESTINATION_SUBINVENTORY VARCHAR2 (10)
Destination Subinventory
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (240)
Descriptive flexfield segment
CLOSED_CODE VARCHAR2 (30)
Closed Code
ASN_TYPE VARCHAR2 (25)
ASN Type
BILL_OF_LADING VARCHAR2 (25)
Bill of Lading
SHIPPED_DATE DATE

Shipped Date
FREIGHT_CARRIER_CODE VARCHAR2 (25)
Freight Carrier Code
WAYBILL_AIRBILL_NUM VARCHAR2 (20)
Waybill/Airbill Number
FREIGHT_BILL_NUM VARCHAR2 (35)
Freight Bill Number
VENDOR_LOT_NUM VARCHAR2 (30)
Vendor Lot Number
CONTAINER_NUM VARCHAR2 (35)
Container Number
TRUCK_NUM VARCHAR2 (35)
Truck Number
BAR_CODE_LABEL VARCHAR2 (35)
Bar Code Label
RATE_TYPE_DISPLAY VARCHAR2 (30)
Rate Type Display
MATCH_OPTION VARCHAR2 (25)
Match Option
COUNTRY_OF_ORIGIN_CODE VARCHAR2 (2)
Country of Origin
OE_ORDER_HEADER_ID NUMBER

OE Order Header Identifier
OE_ORDER_NUM NUMBER

OE Order Number
OE_ORDER_LINE_ID NUMBER

OE Order Line Identifier
OE_ORDER_LINE_NUM NUMBER

OE Order Line Number
CUSTOMER_ID NUMBER

Customer Identifier
CUSTOMER_SITE_ID NUMBER

Customer Site Identifier
CUSTOMER_ITEM_NUMBER VARCHAR2 (50)
Customer Item Number
PLL_NOTE_TO_RECEIVER VARCHAR2 (2000)
PO Shipment Note to Receiver
SECONDARY_ORDERED_QTY NUMBER

Secondary Ordered Quantity
SECONDARY_ORDERED_UOM VARCHAR2 (25)
Secondary Ordered Unit of Measure
QC_GRADE VARCHAR2 (150)
QC Grade
LPN_ID NUMBER

LPN Identifier
SECONDARY_DEFAULT_IND VARCHAR2 (30)
Secondary Default
ORG_ID NUMBER

Organization identifier
OE_ORDER_SHIP_NUM NUMBER

OE Order Shipment Number
PARTY_ID NUMBER (15)
Party Identifier

[top of page]

APPS.INL_RMA_SOURCE_LINES_V references the following:

APPS
PACKAGE - ARPT_SQL_FUNC_UTIL
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
VIEW - HZ_CUSTOMER_PARTY_FIND_V
VIEW - INL_ENTER_RECEIPTS_V
PACKAGE - OE_SYS_PARAMETERS

APPS.INL_RMA_SOURCE_LINES_V is not referenced by any database object

[top of page]

View: INL_SHIPLN_LANDED_COSTS_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view shows landed cost information for Shipment Lines

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

Inventory 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
VIEW - INL_ALLOCATION_SUMMARY_V
APPS.INL_SHIPLN_LANDED_COSTS_V is referenced by following:

APPS
PACKAGE BODY - INL_INTEGRATION_GRP
PACKAGE - INL_INTEGRATION_GRP
PACKAGE BODY - INL_LANDEDCOST_PUB
VIEW - INL_SHIP_LANDED_COSTS_V
PACKAGE - RCV_INSERT_FROM_INL

[top of page]

View: INL_SHIP_LANDED_COSTS_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view shows landed cost information for a Shipment.

Columns
Name Datatype Length Mandatory Comments
SHIP_HEADER_ID NUMBER
Y Shipment Identifier
ADJUSTMENT_NUM NUMBER
Y Adjustment Number
ORGANIZATION_ID NUMBER
Y Inventory Organization Identifier
INVENTORY_ITEM_ID NUMBER

Inventory Item Identifier
ITEM_PRICE NUMBER

Inventory 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_SHIP_LANDED_COSTS_V references the following:

APPS
VIEW - INL_SHIPLN_LANDED_COSTS_V
APPS.INL_SHIP_LANDED_COSTS_V is referenced by following:

APPS
VIEW - INL_DET_LANDED_COSTS_V

[top of page]

View: INL_SHIP_LINE_TYPES_VL

Comments
View Type

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

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 referenced by following:

APPS
PACKAGE BODY - INL_SHIPMENT_PVT

[top of page]

View: INL_SHIP_OVERALL_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view shows overall information on Shipments and their sources such as Purchase Orders, Internal Requisitions and RMA.

Columns
Name Datatype Length Mandatory Comments
SHIP_HEADER_ID NUMBER

ORGANIZATION_ID NUMBER

LOCATION_ID NUMBER

ORG_ID NUMBER

SHIP_TYPE_ID NUMBER

SHIP_TYPE_CODE VARCHAR2 (15)
SHIP_NUM VARCHAR2 (25)
SHIP_DATE DATE

SHIP_STATUS_CODE VARCHAR2 (30)
PENDING_MATCHING_FLAG VARCHAR2 (1)
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 Inventory Organization Identifier
GROUP_ORGANIZATION_NAME VARCHAR2 (240)
Group Inventory 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

Source Identifier, according to the Source Type Code
SHIP_LINE_TYPE_CODE VARCHAR2 (15)
Shipment Line Type Code
ITEM_ID NUMBER

Inventory Item Identifier
ITEM VARCHAR2 (40)
Inventory Item Segment 1
ITEM_REVISION VARCHAR2 (3)
Inventory Item Revision
ITEM_DESCRIPTION VARCHAR2 (240)
Inventory 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 Code
SRC_NUMBER VARCHAR2 (40)
Source Number
SRC_DESCRIPTION VARCHAR2 (240)
Source Description
SRC_ORG_ID NUMBER

Source Operating Unit
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 (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 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)
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 Identitier
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 DATE

Source Shipped Date
SRC_QTY NUMBER

Source Quantity
SRC_ITEM_ID NUMBER

Source Item Identifier
SRC_ITEM_REVISION VARCHAR2 (3)
Source Item Revision
SRC_ITEM_DESCRIPTION VARCHAR2 (240)
Source Item Description
SRC_CONTAINER_NUM VARCHAR2 (35)
Source Customer Identifier
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 Container Number
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_OVERALL_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUP_VALUES_VL
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
SYNONYM - HZ_CUST_ACCT_SITES
SYNONYM - HZ_CUST_SITE_USES
SYNONYM - HZ_PARTIES
SYNONYM - HZ_PARTY_SITES
VIEW - INL_ADJ_SHIP_LINES_V
SYNONYM - INL_SHIP_HEADERS
SYNONYM - INL_SHIP_LINES
SYNONYM - INL_SHIP_LINE_GROUPS
SYNONYM - INL_SHIP_LINE_TYPES_B
SYNONYM - INL_SHIP_TYPES_B
VIEW - MTL_SYSTEM_ITEMS_VL
SYNONYM - OE_ORDER_HEADERS
SYNONYM - OE_ORDER_LINES
VIEW - OE_SOLD_TO_ORGS_V
VIEW - ORG_ORGANIZATION_DEFINITIONS
SYNONYM - PO_HEADERS
SYNONYM - PO_LINES
SYNONYM - PO_LINE_LOCATIONS
SYNONYM - PO_RELEASES
SYNONYM - PO_REQUISITION_HEADERS
SYNONYM - PO_REQUISITION_LINES
VIEW - PO_VENDORS
VIEW - PO_VENDOR_SITES
SYNONYM - RCV_SHIPMENT_HEADERS
SYNONYM - RCV_SHIPMENT_LINES
SYNONYM - RCV_SUPPLY
SYNONYM - RCV_TRANSACTIONS

APPS.INL_SHIP_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.)

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
PACKAGE BODY - INL_SHIPMENT_PVT

[top of page]



Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract