Product: | PO - Purchasing |
---|---|
Description: | Security view for owned purchase order lines |
Implementation/DBA Data: | APPS.PO_OWNED_LINES |
SELECT POL.PO_LINE_ID
, POL.LAST_UPDATE_DATE
, POL.LAST_UPDATED_BY
, POL.PO_HEADER_ID
, POL.LINE_TYPE_ID
, POL.LINE_NUM
, POH.AGENT_ID
, POH.TYPE_LOOKUP_CODE
, POL.LAST_UPDATE_LOGIN
, POL.CREATION_DATE
, POL.CREATED_BY
, POL.ITEM_ID
, POL.ITEM_REVISION
, POL.CATEGORY_ID
, POL.ITEM_DESCRIPTION
, POL.UNIT_MEAS_LOOKUP_CODE
, POL.QUANTITY_COMMITTED
, POL.COMMITTED_AMOUNT
, POL.ALLOW_PRICE_OVERRIDE_FLAG
, POL.NOT_TO_EXCEED_PRICE
, POL.LIST_PRICE_PER_UNIT
, POL.UNIT_PRICE
, POL.QUANTITY
, POL.UN_NUMBER_ID
, POL.HAZARD_CLASS_ID
, POL.NOTE_TO_VENDOR
, POL.FROM_HEADER_ID
, POL.FROM_LINE_ID
, POL.MIN_ORDER_QUANTITY
, POL.MAX_ORDER_QUANTITY
, POL.QTY_RCV_TOLERANCE
, POL.OVER_TOLERANCE_ERROR_FLAG
, POL.MARKET_PRICE
, POL.UNORDERED_FLAG
, POL.CLOSED_CODE
, POL.USER_HOLD_FLAG
, POL.CANCEL_FLAG
, POL.CANCELLED_BY
, POL.CANCEL_DATE
, POL.CANCEL_REASON
, POL.FIRM_STATUS_LOOKUP_CODE
, POL.FIRM_DATE
, POL.VENDOR_PRODUCT_NUM
, POL.CONTRACT_NUM
, POL.TAXABLE_FLAG
, POL.TYPE_1099
, POL.CAPITAL_EXPENSE_FLAG
, POL.NEGOTIATED_BY_PREPARER_FLAG
, POL.USSGL_TRANSACTION_CODE
, POL.GOVERNMENT_CONTEXT
, POL.REFERENCE_NUM
, POL.ATTRIBUTE_CATEGORY
, POL.ATTRIBUTE1
, POL.ATTRIBUTE2
, POL.ATTRIBUTE3
, POL.ATTRIBUTE4
, POL.ATTRIBUTE5
, POL.ATTRIBUTE6
, POL.ATTRIBUTE7
, POL.ATTRIBUTE8
, POL.ATTRIBUTE9
, POL.ATTRIBUTE10
, POL.ATTRIBUTE11
, POL.ATTRIBUTE12
, POL.ATTRIBUTE13
, POL.ATTRIBUTE14
, POL.ATTRIBUTE15
, POL.TAX_CODE_ID
, POL.ORG_ID
FROM PO_LINES POL
, PO_HEADERS_ALL POH
WHERE POH.PO_HEADER_ID = POL.PO_HEADER_ID