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

VIEW: APPS.PO_SP_VAL_V

Object Details
Object Name: PO_SP_VAL_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_NUMBER VARCHAR2 (50)
Document number - Combined with type_lookup_code and org_id to form unique key
OPERATING_UNIT_NAME VARCHAR2 (240)
BUSINESS_GROUP_ID NUMBER (15)
DOCUMENT_TYPE VARCHAR2 (240)
AUTHORIZATION_STATUS_DSP VARCHAR2 (80)
PO_HEADER_ID NUMBER

DESCRIPTION VARCHAR2 (240)
ORG_ID NUMBER

Organization identifier
PO_LINE_ID NUMBER

LINE_NUMBER NUMBER

LINE_LOCATION_ID NUMBER

PO_DISTRIBUTION_ID NUMBER

VENDOR_ID NUMBER

VENDOR_SITE_ID NUMBER

VENDOR_NAME VARCHAR2 (240)
VENDOR_SITE_NAME VARCHAR2 (15)
BUYER_ID NUMBER (9)
BUYER_FULL_NAME VARCHAR2 (240)
POL_START_DATE DATE

POL_EXPIRATION_DATE DATE

JOB_ID NUMBER

PROJECT_ID NUMBER

TASK_ID NUMBER

PERSON_ID NUMBER (10)
ASSIGNMT_EFFECTIVE_START_DATE DATE

ASSIGNMT_EFFECTIVE_END_DATE DATE

VALIDATE_PROJECT_FLAG VARCHAR2 (1)
Query Text

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


SELECT PO_NUMBER
,      OPERATING_UNIT_NAME
,      BUSINESS_GROUP_ID
,      DOCUMENT_TYPE
,      AUTHORIZATION_STATUS_DSP
,      PO_HEADER_ID
,      DESCRIPTION
,      ORG_ID
,      PO_LINE_ID
,      LINE_NUMBER
,      LINE_LOCATION_ID
,      PO_DISTRIBUTION_ID
,      VENDOR_ID
,      VENDOR_SITE_ID
,      VENDOR_NAME
,      VENDOR_SITE_NAME
,      BUYER_ID
,      BUYER_FULL_NAME
,      POL_START_DATE
,      POL_EXPIRATION_DATE
,      JOB_ID
,      PROJECT_ID
,      TASK_ID
,      PERSON_ID
,      ASSIGNMT_EFFECTIVE_START_DATE
,      ASSIGNMT_EFFECTIVE_END_DATE
,      VALIDATE_PROJECT_FLAG
FROM APPS.PO_SP_VAL_V;

Dependencies

[top of page]

APPS.PO_SP_VAL_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
PL/SQL PackageFND_PROFILE - show dependent code
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
PL/SQL PackageHR_GENERAL - show dependent code
SynonymPA_IMPLEMENTATIONS_ALL
SynonymPA_PROJECTS_ALL
SynonymPA_PROJECT_TYPES_ALL
SynonymPER_ALL_ASSIGNMENTS_F
SynonymPER_ALL_PEOPLE_F
SynonymPO_CWK_ASSOCIATIONS
SynonymPO_DISTRIBUTIONS_ALL
ViewPO_DOC_STYLE_LINES_VL
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS_ALL
ViewPO_LOOKUP_CODES
ViewPO_VENDORS
ViewPO_VENDOR_SITES_ALL
APPS.PO_SP_VAL_V is referenced by following:

SchemaAPPS
Package BodyPO_PA_INTEGRATION_GRP - show dependent code
ViewPO_SP_UNIQUE_VAL_V
Package BodyRCV_HXT_GRP - show dependent code