View: PO_TEMP_LABOR_LINES_V

Product:	PO - Purchasing
Description:	Retrieves information on Temp Labor lines.
Implementation/DBA Data:	APPS.PO_TEMP_LABOR_LINES_V

View Text

SELECT POL.LINE_NUM LINE_NUMBER
, POL.PO_HEADER_ID PO_HEADER_ID
, POL.CONTRACTOR_FIRST_NAME CONTRACTOR_FIRST_NAME
, POL.CONTRACTOR_LAST_NAME CONTRACTOR_LAST_NAME
, POL.JOB_ID JOB_ID
, POL.AMOUNT AMOUNT
, POL.PO_LINE_ID PO_LINE_ID
, POL.START_DATE START_DATE
, POL.EXPIRATION_DATE END_DATE
FROM PO_LINES_ALL POL
, PO_LINE_TYPES_B POLT
WHERE NVL(POL.CANCEL_FLAG
, 'N') <> 'Y'
AND POL.LINE_TYPE_ID = POLT.LINE_TYPE_ID
AND POLT.PURCHASE_BASIS = 'TEMP LABOR'

Columns