[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 |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SHIP_HEADER_ID | NUMBER | Yes | Shipment Header Identifier | |
ADJUSTMENT_NUM | NUMBER | Yes | Adjustment Number | |
SHIP_LINE_GROUP_ID | NUMBER | Yes | Line Group Identifier | |
SHIP_LINE_ID | NUMBER | Yes | Shipment Line Identifier | |
PARENT_SHIP_LINE_ID | NUMBER | Parent Shipment Line Identifier | ||
SHIP_LINE_NUM | NUMBER | Yes | Shipment Line Number | |
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 |
COMPONENT_TYPE | VARCHAR2 | (10) | Component Type | |
COMPONENT_CODE | VARCHAR2 | (40) | Component Code | |
COMPONENT_NAME | VARCHAR2 | (80) | Component Name | |
CHARGE_LINE_TYPE_ID | NUMBER | Charge Line Type Identifier | ||
ALLOCATED_AMT | NUMBER | Allocated Amount | ||
ALLOCATION_PERCENT | NUMBER | Allocation Percent | ||
ESTIMATED_ALLOCATED_AMT | NUMBER | Estimated Allocated Amount | ||
ESTIMATED_ALLOCATION_PERCENT | NUMBER | Estimated Percentual of Allocation |
Cut, paste (and edit) the following text to query this object:
SELECT SHIP_HEADER_ID
, ADJUSTMENT_NUM
, SHIP_LINE_GROUP_ID
, SHIP_LINE_ID
, PARENT_SHIP_LINE_ID
, SHIP_LINE_NUM
, ORGANIZATION_ID
, INVENTORY_ITEM_ID
, INV_ITEM
, PRIMARY_QTY
, UNIT_OF_MEASURE
, COMPONENT_TYPE
, COMPONENT_CODE
, COMPONENT_NAME
, CHARGE_LINE_TYPE_ID
, ALLOCATED_AMT
, ALLOCATION_PERCENT
, ESTIMATED_ALLOCATED_AMT
, ESTIMATED_ALLOCATION_PERCENT
FROM APPS.INL_DET_LANDED_COSTS_V;
|
|
|