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


VIEW: APPS.CHV_RECEIVING_TRANSACTIONS_V

Object Details
Object Name: CHV_RECEIVING_TRANSACTIONS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCHV.CHV_RECEIVING_TRANSACTIONS_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
RECEIVER VARCHAR2 (240)
TRANSACTION_DATE DATE

PRIMARY_UNIT_OF_MEASURE VARCHAR2 (25)
UNIT_OF_MEASURE VARCHAR2 (25)
SHIPMENT_HEADER_ID NUMBER

RECEIPT_NUM VARCHAR2 (30)
CREATION_DATE DATE

TRANSACTION_TYPE VARCHAR2 (80)
TRANSACTION_UOM_QUANTITY NUMBER

PRIMARY_UOM_QUANTITY NUMBER

PURCHASING_UOM_QUANTITY NUMBER

VENDOR_ID NUMBER

VENDOR_SITE_ID NUMBER

ITEM_ID NUMBER

ORGANIZATION_ID NUMBER

SHIPMENT_LINE_ID NUMBER

ORG_ID NUMBER

Query Text

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


SELECT RECEIVER
,      TRANSACTION_DATE
,      PRIMARY_UNIT_OF_MEASURE
,      UNIT_OF_MEASURE
,      SHIPMENT_HEADER_ID
,      RECEIPT_NUM
,      CREATION_DATE
,      TRANSACTION_TYPE
,      TRANSACTION_UOM_QUANTITY
,      PRIMARY_UOM_QUANTITY
,      PURCHASING_UOM_QUANTITY
,      VENDOR_ID
,      VENDOR_SITE_ID
,      ITEM_ID
,      ORGANIZATION_ID
,      SHIPMENT_LINE_ID
,      ORG_ID
FROM APPS.CHV_RECEIVING_TRANSACTIONS_V;

Dependencies

[top of page]

APPS.CHV_RECEIVING_TRANSACTIONS_V references the following:

SchemaAPPS
SynonymCHV_CUM_ADJUSTMENTS
PL/SQL PackageFND_GLOBAL - show dependent code
PL/SQL PackageFND_PROFILE - show dependent code
ViewHR_EMPLOYEES
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymPO_HEADERS
ViewPO_LOOKUP_CODES
SynonymRCV_SHIPMENT_HEADERS
SynonymRCV_SHIPMENT_LINES
SynonymRCV_TRANSACTIONS

APPS.CHV_RECEIVING_TRANSACTIONS_V is not referenced by any database object