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

TABLE: PO.PO_RCV_CHARGES

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


This table stores charge records against their backing rcv shipments. If shipment_line_id is null, the charge is a header level charge, otherwise, it's a line level charge.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PO_RCV_CHARGES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCHARGE_ID
PO_RCV_CHARGES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSHIPMENT_HEADER_ID
PO_RCV_CHARGES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSHIPMENT_LINE_ID
Columns
Name Datatype Length Mandatory Comments
CHARGE_ID NUMBER
Yes Entity identifier
SHIPMENT_HEADER_ID NUMBER
Yes Identifer of the item shipment header that is being charged. All charges must have a backing item shipment header
SHIPMENT_LINE_ID NUMBER

Identifier of the shipment line that is being charged. For header level charge this field is null.
INTERFACE_CHARGE_ID NUMBER

Identifier of the Charge Interface row that this charge was created from.
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).
COST_FACTOR_ID NUMBER
Yes Identifier of the Cost Factor of this charge
CURRENCY_CODE VARCHAR2 (15)
Charge currency code
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
Currency conversion type
CURRENCY_CONVERSION_RATE NUMBER

Currency conversion rate
CURRENCY_CONVERSION_DATE DATE

Currency conversion date
ALLOCATION_METHOD VARCHAR2 (30)
Basis of allocation. Possible values are: WEIGHT, VALUE, QUANTITY, VOLUME
UNIT_OF_MEASURE VARCHAR2 (25)
Reserve for Costing use
ESTIMATED_AMOUNT NUMBER

Estimated charge amount
ACTUAL_AMOUNT NUMBER

Actual charge amount
INCLUDE_IN_ACQUISITION_COST VARCHAR2 (1)
Whether this charge should be included in acqusition cost report
VENDOR_ID NUMBER

Internal identifier of the charge provider
VENDOR_SITE_ID NUMBER

Internal identifier of the charge provider site
ESTIMATED_TAX NUMBER

Estimated tax on this charge
ACTUAL_TAX NUMBER

Billed tax on this charge
COST_COMPONENT_CLASS_ID NUMBER

OPM required
COST_ANALYSIS_CODE VARCHAR2 (15)
OPM required
Query Text

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


SELECT CHARGE_ID
,      SHIPMENT_HEADER_ID
,      SHIPMENT_LINE_ID
,      INTERFACE_CHARGE_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      COST_FACTOR_ID
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_DATE
,      ALLOCATION_METHOD
,      UNIT_OF_MEASURE
,      ESTIMATED_AMOUNT
,      ACTUAL_AMOUNT
,      INCLUDE_IN_ACQUISITION_COST
,      VENDOR_ID
,      VENDOR_SITE_ID
,      ESTIMATED_TAX
,      ACTUAL_TAX
,      COST_COMPONENT_CLASS_ID
,      COST_ANALYSIS_CODE
FROM PO.PO_RCV_CHARGES;

Dependencies

[top of page]

PO.PO_RCV_CHARGES does not reference any database object

PO.PO_RCV_CHARGES is referenced by following:

SchemaPO
ViewPO_RCV_CHARGES#