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: ViewPO.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 Mandatory 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:

SchemaAPPS
ViewFND_CURRENCIES_VL
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
SynonymMTL_UNITS_OF_MEASURE
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_LINE_TYPES_B
SynonymPO_PRICE_DIFFERENTIALS
APPS.PO_TEMP_LABOR_RATES_V is referenced by following:

SchemaAPPS
Package BodyPO_STORE_TIMECARD_PKG_GRP - show dependent code
Package BodyRCV_HXT_GRP - show dependent code