VIEW: APPS.PO_TEMP_LABOR_RATES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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