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_RATES_V

Object Details

Object Name:	PO_TEMP_LABOR_RATES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PO.PO_TEMP_LABOR_RATES_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	Comments
PO_LINE_ID	NUMBER		Identifier for the PO line
CURRENCY_NAME	VARCHAR2	(80)	Display name of the currency on the PO header
CURRENCY_CODE	VARCHAR2	(15)	Code of the currency on the PO header
RATE_VALUE	NUMBER		Rate for this PO line and rate type combination; equal to PO_LINES_ALL.unit_price for standard line rates (ASG_RATE_TYPE='STANDARD'), or PO_LINES_ALL.unit_price * PO_PRICE_DIFFERENTIALS.multiplier for calculated, price differential rates.
RATE_BASIS	VARCHAR2	(25)	Code of the unit of measure on the PO line
RATE_BASIS_DSP	VARCHAR2	(25)	Display name of the unit of measure on the PO line
ASG_RATE_TYPE	VARCHAR2	(30)	Rate type for this record: 'STANDARD' for a rate taken from the price on the PO line, PO_PRICE_DIFFERENTIALS.price_type for a rate calculated using the multipler on a price differential
PRICE_TYPE_DSP	VARCHAR2	(80)	Display name of the rate type for this record
START_DATE	DATE		Contractor assignment start date
END_DATE	DATE		Contractor assignment end date
CURRENCY_RATE	NUMBER		Currency conversion rate from the PO header
CURRENCY_RATE_TYPE	VARCHAR2	(30)	Currency conversion type from the PO header
CURRENCY_RATE_DATE	DATE		Currency conversion date from the PO header

Query Text

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


SELECT PO_LINE_ID
,      CURRENCY_NAME
,      CURRENCY_CODE
,      RATE_VALUE
,      RATE_BASIS
,      RATE_BASIS_DSP
,      ASG_RATE_TYPE
,      PRICE_TYPE_DSP
,      START_DATE
,      END_DATE
,      CURRENCY_RATE
,      CURRENCY_RATE_TYPE
,      CURRENCY_RATE_DATE
FROM APPS.PO_TEMP_LABOR_RATES_V;

Dependencies

[top of page]

APPS.PO_TEMP_LABOR_RATES_V references the following:

APPS: FND_CURRENCIES_VL; FND_GLOBAL - show dependent code; FND_LOOKUPS; MTL_UNITS_OF_MEASURE; PO_HEADERS_ALL; PO_LINES_ALL; PO_LINE_TYPES_B; PO_PRICE_DIFFERENTIALS

APPS.PO_TEMP_LABOR_RATES_V is referenced by following:

APPS: PO_STORE_TIMECARD_PKG_GRP - show dependent code; RCV_HXT_GRP - show dependent code