[Home] [Help] [Dependency Information]
Object Name: | INL_ALLOCATION_FLOW_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | INL.INL_ALLOCATION_FLOW_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view shows information on the flow of the Shipment amounts to get the corresponding Shipment Lines.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SHIP_HEADER_ID | NUMBER | Shipment Identifier | ||
ADJUSTMENT_NUM | NUMBER | Adjustment Number | ||
ASSOCIATION_ID | NUMBER | Association Identifier | ||
PARENT_TABLE_NAME | VARCHAR2 | (30) | Name of the table the amount comes from: INL_SHIP_HEADERS, INL_SHIP_LINE_GROUPS, INL_SHIP_LINES, INL_CHARGE_LINES, INL_TAX_LINES | |
PARENT_TABLE_ID | NUMBER | Identifier of the table line the amount comes from: SHIP_HEADER_ID, SHIP_LINE_GROUP_ID, SHIP_LINE_ID, CHARGE_LINE_ID, TAX_LINE_ID | ||
ALLOCATION_AMT | NUMBER | Allocation Amount | ||
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 |
Cut, paste (and edit) the following text to query this object:
SELECT SHIP_HEADER_ID
, ADJUSTMENT_NUM
, ASSOCIATION_ID
, PARENT_TABLE_NAME
, PARENT_TABLE_ID
, ALLOCATION_AMT
, ASSOC_FROM_PARENT_TABLE_NAME
, ASSOC_FROM_PARENT_TABLE_ID
FROM APPS.INL_ALLOCATION_FLOW_V;
APPS.INL_ALLOCATION_FLOW_V is not referenced by any database object
|
|
|