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


TABLE: PO.PO_RCV_CHARGE_ALLOCATIONS

Object Details
Object Name: PO_RCV_CHARGE_ALLOCATIONS
Object Type: TABLE
Owner: PO
FND Design Data: TablePO.PO_RCV_CHARGE_ALLOCATIONS
Subobject Name:
Status: VALID


This table stores charges that have been allocated to the rcv shipment line level.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PO_RCV_CHARGE_ALLOCATIONS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCHARGE_ID
PO_RCV_CHARGE_ALLOCATIONS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSHIPMENT_LINE_ID
PO_RCV_CHARGE_ALLOCATIONS_U1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCHARGE_ALLOCATION_ID
Columns
Name Datatype Length Mandatory Comments
CHARGE_ALLOCATION_ID NUMBER
Yes Entity identifier
CHARGE_ID NUMBER
Yes Idendifier of the backing charge record
SHIPMENT_LINE_ID NUMBER
Yes Identifier of the item shipment line agaisnt which the allocation is calculated
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER
Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
ESTIMATED_AMOUNT NUMBER

Allocated estimated charge amount
ACTUAL_AMOUNT NUMBER

Allocated actual charge amount
ORIGINAL_UNIT_PRICE NUMBER

Reserved for Costing use
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 PO.PO_RCV_CHARGE_ALLOCATIONS;

Dependencies

[top of page]

PO.PO_RCV_CHARGE_ALLOCATIONS does not reference any database object

PO.PO_RCV_CHARGE_ALLOCATIONS is referenced by following:

SchemaPO
ViewPO_RCV_CHARGE_ALLOCATIONS#