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

VIEW: APPS.PO_POS_ALL_TRX_V

Object Details
Object Name: PO_POS_ALL_TRX_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.PO_POS_ALL_TRX_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


10SC ONLY - Retrofitted


[View Source]

Columns
Name Datatype Length Mandatory Comments
SEGMENT1 VARCHAR2 (50)
Key flexfield segment
TYPE_NAME VARCHAR2 (80)
CREATION_DATE DATE

Standard who column - date when this row was created.
PO_HEADER_ID NUMBER

VENDOR_NAME VARCHAR2 (360)
AGENT_ID NUMBER (9)
DISPLAYED_FIELD VARCHAR2 (80)
COMMENTS VARCHAR2 (240)
SECURITY_LEVEL_CODE VARCHAR2 (25)
FULL_NAME VARCHAR2 (4000)
TYPE_LOOKUP_CODE VARCHAR2 (25)
VENDOR_ID NUMBER

AUTHORIZATION_STATUS VARCHAR2 (25)
AUTHORIZATION_STATUS_DSP VARCHAR2 (80)
GLOBAL_AGREEMENT_FLAG VARCHAR2 (1)
OWNING_ORG VARCHAR2 (240)
ORG_ID NUMBER

Organization identifier
STYLE_ID NUMBER

Query Text

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


SELECT SEGMENT1
,      TYPE_NAME
,      CREATION_DATE
,      PO_HEADER_ID
,      VENDOR_NAME
,      AGENT_ID
,      DISPLAYED_FIELD
,      COMMENTS
,      SECURITY_LEVEL_CODE
,      FULL_NAME
,      TYPE_LOOKUP_CODE
,      VENDOR_ID
,      AUTHORIZATION_STATUS
,      AUTHORIZATION_STATUS_DSP
,      GLOBAL_AGREEMENT_FLAG
,      OWNING_ORG
,      ORG_ID
,      STYLE_ID
FROM APPS.PO_POS_ALL_TRX_V;

Dependencies

[top of page]

APPS.PO_POS_ALL_TRX_V references the following:

SchemaAPPS
SynonymAP_SUPPLIERS
SynonymFINANCIALS_SYSTEM_PARAMETERS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymFND_LOOKUP_VALUES
SynonymHR_ALL_ORGANIZATION_UNITS_TL
SynonymHZ_PARTIES
SynonymPO_DOCUMENT_TYPES_ALL_B
SynonymPO_DOCUMENT_TYPES_ALL_TL
PL/SQL PackagePO_EMPLOYEES_SV - show dependent code
SynonymPO_GA_ORG_ASSIGNMENTS
SynonymPO_HEADERS_ALL
APPS.PO_POS_ALL_TRX_V is referenced by following:

SchemaAPPS
ViewQA_PO_NUMBERS_LOV_V