VIEW: APPS.PO_LINES_AP_V

Source

View Text - Preformatted

SELECT PL.PO_HEADER_ID PO_HEADER_ID , PL.PO_LINE_ID PO_LINE_ID , PH.VENDOR_ID VENDOR_ID , PH.APPROVED_FLAG APPROVED_FLAG , PH.CURRENCY_CODE CURRENCY_CODE , PL.LINE_NUM PO_LINE_NUM , PL.ITEM_DESCRIPTION ITEM_DESCRIPTION , PL.ORG_ID FROM PO_LINES PL, PO_HEADERS_ALL PH WHERE PL.PO_HEADER_ID = PH.PO_HEADER_ID

View Text - HTML Formatted

SELECT PL.PO_HEADER_ID PO_HEADER_ID
, PL.PO_LINE_ID PO_LINE_ID
, PH.VENDOR_ID VENDOR_ID
, PH.APPROVED_FLAG APPROVED_FLAG
, PH.CURRENCY_CODE CURRENCY_CODE
, PL.LINE_NUM PO_LINE_NUM
, PL.ITEM_DESCRIPTION ITEM_DESCRIPTION
, PL.ORG_ID
FROM PO_LINES PL
, PO_HEADERS_ALL PH
WHERE PL.PO_HEADER_ID = PH.PO_HEADER_ID