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

VIEW: APPS.PO_TRANSACTION_V

Object Details
Object Name: PO_TRANSACTION_V
Object Type: VIEW
Owner: APPS
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
PO_HEADER_ID NUMBER
Yes Document header unique identifier
PO_DOC_NUMBER VARCHAR2 (20) Yes Document number - Combined with type_lookup_code and org_id to form unique key
PO_DOC_TYPE VARCHAR2 (25) Yes Type of the document. (Combined with segment1and org_id to form unique key; References PO_DOCUMENT_TYPES_ALL_B.document_subtype)
VENDOR_ID NUMBER

Supplier unique identifier (References PO_VENDORS.vendor_id)
VENDOR_NAME VARCHAR2 (240)
Supplier name
VENDOR_SITE_ID NUMBER

Supplier site unique identifier (References PO_VENDOR_SITES_ALL.vendor_site_id)
VENDOR_SITE_CODE VARCHAR2 (15)
Site code name
BUYER_ID NUMBER (9) Yes Buyer unique identifier. (References PO_AGENTS.agent_id)
BUYER_NAME VARCHAR2 (240)
Full concatenated name of the employee
CREATION_DATE DATE

Standard who column - date when this row was created.
Query Text

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


SELECT PO_HEADER_ID
,      PO_DOC_NUMBER
,      PO_DOC_TYPE
,      VENDOR_ID
,      VENDOR_NAME
,      VENDOR_SITE_ID
,      VENDOR_SITE_CODE
,      BUYER_ID
,      BUYER_NAME
,      CREATION_DATE
FROM APPS.PO_TRANSACTION_V;

Dependencies

[top of page]

APPS.PO_TRANSACTION_V references the following:

SchemaAPPS
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_ALL
ViewPO_VENDORS
ViewPO_VENDOR_SITES_ALL

APPS.PO_TRANSACTION_V is not referenced by any database object