[Home] [Help] [Dependency Information]
Object Name: | INL_ALLOCATION_SUMMARY_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | INL.INL_ALLOCATION_SUMMARY_V |
Subobject Name: | |
Status: | VALID |
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.
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 | ||
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 | Yes | Allocation Identifier | |
ALLOCATION_AMT | NUMBER | Yes | Allocation Amount | |
LANDED_COST_FLAG | VARCHAR2 | (1) | Yes | "Y" or "N" flag indicating whether the amount should be considered in the landed cost |
Cut, paste (and edit) the following text to query this object:
SELECT SHIP_HEADER_ID
, ADJUSTMENT_NUM
, ORGANIZATION_ID
, INVENTORY_ITEM_ID
, PRIMARY_QTY
, PRIMARY_UOM_CODE
, SHIP_LINE_GROUP_ID
, SHIP_LINE_ID
, SHIP_LINE_NUM
, ASSOCIATION_ID
, ASSOC_FROM_PARENT_TABLE_NAME
, ASSOC_FROM_PARENT_TABLE_ID
, CHARGE_LINE_ID
, TAX_LINE_ID
, ALLOCATION_ID
, ALLOCATION_AMT
, LANDED_COST_FLAG
FROM APPS.INL_ALLOCATION_SUMMARY_V;
|
|
|