[Home] [Help] [Dependency Information]
Object Name: | INL_SHIP_LANDED_COSTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | INL.INL_SHIP_LANDED_COSTS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view shows landed cost information for a Shipment.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SHIP_HEADER_ID | NUMBER | Yes | Shipment Identifier | |
ADJUSTMENT_NUM | NUMBER | Yes | Adjustment Number | |
ORGANIZATION_ID | NUMBER | Yes | 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 |
Cut, paste (and edit) the following text to query this object:
SELECT SHIP_HEADER_ID
, ADJUSTMENT_NUM
, ORGANIZATION_ID
, INVENTORY_ITEM_ID
, ITEM_PRICE
, CHARGES
, TAXES
, PRIMARY_QTY
, PRIMARY_UOM_CODE
, UNIT_LANDED_COST
FROM APPS.INL_SHIP_LANDED_COSTS_V;
|
|
|