[Home] [Help]
View: PO_LINES_AP_V
Product: | PO - Purchasing |
Description: | 10SC ONLY |
Implementation/DBA Data: |
APPS.PO_LINES_AP_V
|
View Text
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
Columns
Name |
PO_HEADER_ID |
PO_LINE_ID |
VENDOR_ID |
APPROVED_FLAG |
CURRENCY_CODE |
PO_LINE_NUM |
ITEM_DESCRIPTION |
ORG_ID |