FND Design Data [Home] [Help]

View: PO_TEMP_LABOR_RATES_V

Product: PO - Purchasing
Description: Retrieves rate information for Temp Labor lines and their price differentials on Standard POs.
Implementation/DBA Data: ViewAPPS.PO_TEMP_LABOR_RATES_V
View Text

SELECT /** PO LINES **/ POL.PO_LINE_ID PO_LINE_ID
, FC.NAME CURRENCY_NAME
, POH.CURRENCY_CODE CURRENCY_CODE
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'RATE'
, POL.UNIT_PRICE
, POL.AMOUNT) RATE_VALUE
, POL.UNIT_MEAS_LOOKUP_CODE RATE_BASIS
, MTL.UNIT_OF_MEASURE_TL RATE_BASIS_DSP
, 'STANDARD' ASG_RATE_TYPE
, FLV.MEANING PRICE_TYPE_DSP
, POL.START_DATE START_DATE
, POL.EXPIRATION_DATE END_DATE
, POH.RATE CURRENCY_RATE
, POH.RATE_TYPE CURRENCY_RATE_TYPE
, POH.RATE_DATE CURRENCY_RATE_DATE
FROM PO_HEADERS_ALL POH
, PO_LINES_ALL POL
, PO_LINE_TYPES_B PLT
, FND_CURRENCIES_VL FC
, FND_LOOKUPS FLV
, MTL_UNITS_OF_MEASURE MTL
WHERE POL.PO_HEADER_ID = POH.PO_HEADER_ID
AND POH.TYPE_LOOKUP_CODE = 'STANDARD'
AND FC.CURRENCY_CODE = POH.CURRENCY_CODE
AND POL.LINE_TYPE_ID = PLT.LINE_TYPE_ID
AND PLT.ORDER_TYPE_LOOKUP_CODE IN ('RATE'
, 'FIXED PRICE')
AND PLT.PURCHASE_BASIS = 'TEMP LABOR'
AND POL.UNIT_MEAS_LOOKUP_CODE = MTL.UNIT_OF_MEASURE (+)
AND FLV.LOOKUP_TYPE (+) = 'PRICE DIFFERENTIALS'
AND FLV.LOOKUP_CODE (+) = 'STANDARD' UNION ALL SELECT /** PRICE DIFFERENTIALS **/ POL.PO_LINE_ID PO_LINE_ID
, FC.NAME CURRENCY_NAME
, POH.CURRENCY_CODE CURRENCY_CODE
, POL.UNIT_PRICE*NVL(POPD.MULTIPLIER
, 1) RATE_VALUE
, POL.UNIT_MEAS_LOOKUP_CODE RATE_BASIS
, MTL.UNIT_OF_MEASURE_TL RATE_BASIS_DSP
, POPD.PRICE_TYPE ASG_RATE_TYPE
, FLV.MEANING PRICE_TYPE_DSP
, POL.START_DATE START_DATE
, POL.EXPIRATION_DATE END_DATE
, POH.RATE CURRENCY_RATE
, POH.RATE_TYPE CURRENCY_RATE_TYPE
, POH.RATE_DATE CURRENCY_RATE_DATE
FROM PO_HEADERS_ALL POH
, PO_LINES_ALL POL
, PO_PRICE_DIFFERENTIALS POPD
, PO_LINE_TYPES_B PLT
, FND_CURRENCIES_VL FC
, FND_LOOKUPS FLV
, MTL_UNITS_OF_MEASURE MTL
WHERE POL.PO_HEADER_ID = POH.PO_HEADER_ID
AND POH.TYPE_LOOKUP_CODE = 'STANDARD'
AND FC.CURRENCY_CODE = POH.CURRENCY_CODE
AND POPD.ENTITY_ID = POL.PO_LINE_ID
AND POPD.ENTITY_TYPE = 'PO LINE'
AND POPD.ENABLED_FLAG = 'Y'
AND POL.LINE_TYPE_ID = PLT.LINE_TYPE_ID
AND PLT.ORDER_TYPE_LOOKUP_CODE IN ('RATE'
, 'FIXED PRICE')
AND PLT.PURCHASE_BASIS = 'TEMP LABOR'
AND POL.UNIT_MEAS_LOOKUP_CODE = MTL.UNIT_OF_MEASURE (+)
AND FLV.LOOKUP_TYPE (+) = 'PRICE DIFFERENTIALS'
AND FLV.LOOKUP_CODE (+) = POPD.PRICE_TYPE

Columns

Name
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