eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:	PO.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)		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:

APPS: FND_GLOBAL - show dependent code; HR_ALL_ORGANIZATION_UNITS; HR_ALL_ORGANIZATION_UNITS_TL; PER_ALL_PEOPLE_F; PO_DOCUMENT_TYPES_ALL_TL; PO_HEADERS_ALL; PO_LINES_ALL; PO_LINE_TYPES_B; PO_LOOKUP_CODES; PO_VENDORS; PO_VENDOR_SITES_ALL

APPS.PO_TEMP_LABOR_HEADERS_V is referenced by following:

APPS: HR_ASSIGNMENT_API - show dependent code; HR_PROCESS_ASSIGNMENT_SS - show dependent code; PER_ASG_BUS3 - show dependent code