DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.INL_ALLOCATION_FLOW_V

Object Details
Object Name: INL_ALLOCATION_FLOW_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewINL.INL_ALLOCATION_FLOW_V
Subobject Name:
Status: VALID

View Type

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.


[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.INL_ALLOCATION_FLOW_V references the following:

SchemaAPPS
SynonymINL_ALLOCATIONS
SynonymINL_ASSOCIATIONS

APPS.INL_ALLOCATION_FLOW_V is not referenced by any database object