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


VIEW: APPS.PO_POS_ALL_V

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

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

Standard who column - date when this row was created.
PO_HEADER_ID NUMBER
Yes
VENDOR_NAME VARCHAR2 (360)

AGENT_ID NUMBER (9) Yes
DISPLAYED_FIELD VARCHAR2 (80) Yes
COMMENTS VARCHAR2 (240)

SECURITY_LEVEL_CODE VARCHAR2 (25)

FULL_NAME VARCHAR2 (4000)

TYPE_LOOKUP_CODE VARCHAR2 (25) Yes
VENDOR_ID NUMBER

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

Organization identifier
STYLE_ID NUMBER
Yes Identifies the Purchasing Style Associated with the document
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_V;

Dependencies

[top of page]

APPS.PO_POS_ALL_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_V is not referenced by any database object