VIEW: APPS.AHL_OSP_PO_LINES_V

Source

View Text - Preformatted

SELECT PL.PO_LINE_ID, PL.LAST_UPDATE_DATE, PL.LAST_UPDATED_BY, PL.PO_HEADER_ID, PL.LINE_NUM, PL.LAST_UPDATE_LOGIN, PL.CREATION_DATE, PL.CREATED_BY, PL.ITEM_ID, PL.ITEM_DESCRIPTION, PL.UNIT_MEAS_LOOKUP_CODE, PL.UNIT_PRICE, PL.QUANTITY, PL.CANCEL_FLAG, PL.ORG_ID, OL.WORKORDER_ID, WO.WORKORDER_NAME JOB_NUMBER, OSP.OSP_ORDER_ID, OSP.OBJECT_VERSION_NUMBER from PO_LINES_ALL PL, AHL_OSP_ORDER_LINES OL, AHL_OSP_ORDERS_B OSP, AHL_WORKORDERS WO WHERE PL.PO_LINE_ID = OL.PO_LINE_ID (+) AND OL.WORKORDER_ID = WO.WORKORDER_ID (+) AND OSP.PO_HEADER_ID = PL.PO_HEADER_ID

View Text - HTML Formatted

SELECT PL.PO_LINE_ID
, PL.LAST_UPDATE_DATE
, PL.LAST_UPDATED_BY
, PL.PO_HEADER_ID
, PL.LINE_NUM
, PL.LAST_UPDATE_LOGIN
, PL.CREATION_DATE
, PL.CREATED_BY
, PL.ITEM_ID
, PL.ITEM_DESCRIPTION
, PL.UNIT_MEAS_LOOKUP_CODE
, PL.UNIT_PRICE
, PL.QUANTITY
, PL.CANCEL_FLAG
, PL.ORG_ID
, OL.WORKORDER_ID
, WO.WORKORDER_NAME JOB_NUMBER
, OSP.OSP_ORDER_ID
, OSP.OBJECT_VERSION_NUMBER
FROM PO_LINES_ALL PL
, AHL_OSP_ORDER_LINES OL
, AHL_OSP_ORDERS_B OSP
, AHL_WORKORDERS WO
WHERE PL.PO_LINE_ID = OL.PO_LINE_ID (+)
AND OL.WORKORDER_ID = WO.WORKORDER_ID (+)
AND OSP.PO_HEADER_ID = PL.PO_HEADER_ID