eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: PO.PO_RCV_CHARGES

Object Details

Object Name:	PO_RCV_CHARGES
Object Type:	TABLE
Owner:	PO
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:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PO_RCV_CHARGES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CHARGE_ID
PO_RCV_CHARGES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SHIPMENT_HEADER_ID
PO_RCV_CHARGES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SHIPMENT_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:

APPS: PO_RCV_CHARGES