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

VIEW: APPS.INL_DET_LANDED_COSTS_V

Object Details
Object Name: INL_DET_LANDED_COSTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewINL.INL_DET_LANDED_COSTS_V
Subobject Name:
Status: VALID

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.


[View Source]

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

Line Group Identifier
SHIP_LINE_ID NUMBER

Shipment Line Identifier
ORGANIZATION_ID NUMBER
Yes 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) Yes 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
Query Text

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


SELECT SHIP_HEADER_ID
,      ADJUSTMENT_NUM
,      SHIP_LINE_GROUP_ID
,      SHIP_LINE_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      INV_ITEM
,      PRIMARY_QTY
,      UNIT_OF_MEASURE
,      ALLOCATED_AMT
,      ALLOCATION_PERCENT
,      COMPONENT_TYPE
,      COMPONENT_NAME
FROM APPS.INL_DET_LANDED_COSTS_V;

Dependencies

[top of page]

APPS.INL_DET_LANDED_COSTS_V references the following:

SchemaAPPS
ViewINL_ALLOCATION_SUMMARY_V
SynonymINL_CHARGE_LINES
ViewINL_CHARGE_LINE_TYPES_VL
ViewINL_SHIP_LANDED_COSTS_V
SynonymINL_TAX_LINES
ViewMTL_SYSTEM_ITEMS_VL
ViewMTL_UNITS_OF_MEASURE_VL

APPS.INL_DET_LANDED_COSTS_V is not referenced by any database object