[Home] [Help] [Dependency Information]
Object Name: | PO_SP_VAL_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PO_NUMBER | VARCHAR2 | (20) | 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) |
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;
|
|
|