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

VIEW: PO.PO_RCV_CHARGES#

Object Details
Object Name: PO_RCV_CHARGES#
Object Type: VIEW
Owner: PO
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
CHARGE_ID NUMBER
Yes
SHIPMENT_HEADER_ID NUMBER
Yes
SHIPMENT_LINE_ID NUMBER

INTERFACE_CHARGE_ID NUMBER

CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
COST_FACTOR_ID NUMBER
Yes
CURRENCY_CODE VARCHAR2 (15)
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
CURRENCY_CONVERSION_RATE NUMBER

CURRENCY_CONVERSION_DATE DATE

ALLOCATION_METHOD VARCHAR2 (30)
UNIT_OF_MEASURE VARCHAR2 (25)
ESTIMATED_AMOUNT NUMBER

ACTUAL_AMOUNT NUMBER

INCLUDE_IN_ACQUISITION_COST VARCHAR2 (1)
VENDOR_ID NUMBER

VENDOR_SITE_ID NUMBER

ESTIMATED_TAX NUMBER

ACTUAL_TAX NUMBER

COST_COMPONENT_CLASS_ID NUMBER

COST_ANALYSIS_CODE VARCHAR2 (15)
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# references the following:

SchemaPO
TablePO_RCV_CHARGES
PO.PO_RCV_CHARGES# is referenced by following:

SchemaAPPS
SynonymPO_RCV_CHARGES