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


VIEW: APPS.PO_TEMP_LABOR_HEADERS_V

Object Details
Object Name: PO_TEMP_LABOR_HEADERS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.PO_TEMP_LABOR_HEADERS_V
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 (20) Yes PO number
OPERATING_UNIT_NAME VARCHAR2 (240) Yes Name of the Purchasing Operating Unit for this PO
BUSINESS_GROUP_ID NUMBER (15) Yes Identifier for the business group that the Purchasing Operating Unit belongs to
PO_TYPE VARCHAR2 (80) Yes Display name for the type of the PO
AUTHORIZATION_STATUS_DSP VARCHAR2 (80)
Display name for the authorization status of the PO
PO_HEADER_ID NUMBER
Yes Identifier for the PO header
VENDOR_ID NUMBER

Identifier for the supplier
VENDOR_SITE_ID NUMBER

Identifier for the supplier site
VENDOR_NAME VARCHAR2 (240)
Display name for the supplier
VENDOR_SITE_NAME VARCHAR2 (15) Yes Display name for the supplier site
BUYER_ID NUMBER (9) Yes Identifier for the buyer on the PO
BUYER_FULL_NAME VARCHAR2 (240)
Full name of the buyer on the PO
Query Text

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


SELECT PO_NUMBER
,      OPERATING_UNIT_NAME
,      BUSINESS_GROUP_ID
,      PO_TYPE
,      AUTHORIZATION_STATUS_DSP
,      PO_HEADER_ID
,      VENDOR_ID
,      VENDOR_SITE_ID
,      VENDOR_NAME
,      VENDOR_SITE_NAME
,      BUYER_ID
,      BUYER_FULL_NAME
FROM APPS.PO_TEMP_LABOR_HEADERS_V;

Dependencies

[top of page]

APPS.PO_TEMP_LABOR_HEADERS_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
SynonymPER_ALL_PEOPLE_F
SynonymPO_DOCUMENT_TYPES_ALL_TL
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_LINE_TYPES_B
ViewPO_LOOKUP_CODES
ViewPO_VENDORS
ViewPO_VENDOR_SITES_ALL
APPS.PO_TEMP_LABOR_HEADERS_V is referenced by following:

SchemaAPPS
Package BodyHR_ASSIGNMENT_API - show dependent code
Package BodyHR_PROCESS_ASSIGNMENT_SS - show dependent code
Package BodyPER_ASG_BUS3 - show dependent code