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

VIEW: APPS.INL_PO_CHARGE_ALLOCATIONS_V

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
CHARGE_ALLOCATION_ID NUMBER

Charge Allocation Identifier
CHARGE_ID NUMBER

Charge Identifier
SHIPMENT_LINE_ID NUMBER

Shipment Line Identifier
CREATION_DATE DATE

Standard who column - date when this row was created.
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID)
ESTIMATED_AMOUNT NUMBER

Estimated Amount
ACTUAL_AMOUNT NUMBER

Actual Amount
ORIGINAL_UNIT_PRICE NUMBER

Original Unit Price
ORIGINAL_UNIT_NR_TAX NUMBER

Reserved for Costing use
EST_RECOVERABLE_TAX NUMBER

Estimated recoverable tax amount on this charge allocation
EST_NON_RECOVERABLE_TAX NUMBER

Estimated non_recoverable tax amount on this charge allocation
ACT_RECOVERABLE_TAX NUMBER

Actual recoverable tax amount on this charge allocation
ACT_NON_RECOVERABLE_TAX NUMBER

Actual non-recoverable tax amount on this charge allocation
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CHARGE_ALLOCATION_ID
,      CHARGE_ID
,      SHIPMENT_LINE_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      ESTIMATED_AMOUNT
,      ACTUAL_AMOUNT
,      ORIGINAL_UNIT_PRICE
,      ORIGINAL_UNIT_NR_TAX
,      EST_RECOVERABLE_TAX
,      EST_NON_RECOVERABLE_TAX
,      ACT_RECOVERABLE_TAX
,      ACT_NON_RECOVERABLE_TAX
FROM APPS.INL_PO_CHARGE_ALLOCATIONS_V;

Dependencies

[top of page]

APPS.INL_PO_CHARGE_ALLOCATIONS_V references the following:

SchemaAPPS
SynonymINL_ALLOCATIONS
SynonymINL_CHARGE_LINES
PL/SQL PackageINL_SHIPMENT_PVT - show dependent code
SynonymPO_LINE_LOCATIONS_ALL
SynonymPO_RCV_CHARGE_ALLOCATIONS
SynonymRCV_SHIPMENT_LINES

APPS.INL_PO_CHARGE_ALLOCATIONS_V is not referenced by any database object