VIEW: APPS.PO_TEMP_LABOR_LINES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'