[Home] [Help] [Dependency Information]
Object Name: | INL_DET_LANDED_COSTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | INL.INL_DET_LANDED_COSTS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view shows detailed landed cost information for a Shipment.
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 |
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;
APPS.INL_DET_LANDED_COSTS_V is not referenced by any database object
|
|
|