Product: | PO - Purchasing |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.POBV_PLAN_PO_LINES |
SELECT PL.PO_LINE_ID
, PL.LINE_NUM
, PL.PO_HEADER_ID
, PH.SEGMENT1
, PL.ORG_ID
, OP.NAME
, LT.LINE_TYPE
, PL.ITEM_DESCRIPTION
, PL.QUANTITY
, PL.UNIT_PRICE
, PL.LIST_PRICE_PER_UNIT
, PL.MARKET_PRICE
, '_LA:PL.PRICE_TYPE_LOOKUP_CODE:PO_LOOKUP_CODES:PRICE TYPE:DISPLAYED_FIELD'
, '_LA:PL.ALLOW_PRICE_OVERRIDE_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, PL.NOT_TO_EXCEED_PRICE
, PL.MIN_RELEASE_AMOUNT
, '_LA:PL.CANCEL_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, PL.CANCEL_DATE
, PL.CANCEL_REASON
, '_LA:PL.CLOSED_CODE:PO_LOOKUP_CODES:DOCUMENT STATE:DISPLAYED_FIELD'
, PL.CLOSED_DATE
, PL.CLOSED_REASON
, '_LA:PL.NEGOTIATED_BY_PREPARER_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:PL.CAPITAL_EXPENSE_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, PL.NOTE_TO_VENDOR
, PL.VENDOR_PRODUCT_NUM
, '_LA:PL.TAXABLE_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, PL.TYPE_1099
, PL.TRANSACTION_REASON_CODE
, PL.USSGL_TRANSACTION_CODE
, PL.ITEM_ID
, PL.ITEM_REVISION
, PL.CATEGORY_ID
, PL.UNIT_MEAS_LOOKUP_CODE
, PL.HAZARD_CLASS_ID
, PL.UN_NUMBER_ID
, PL.FROM_HEADER_ID
, PL.FROM_LINE_ID
, PL.CANCELLED_BY
, PL.CLOSED_BY
, PL.TAX_CODE_ID
, PL.CREATION_DATE
, PL.CREATED_BY
, PL.LAST_UPDATE_DATE
, PL.LAST_UPDATED_BY
, PL.SECONDARY_QUANTITY
, PL.SECONDARY_UNIT_OF_MEASURE
, PL.PREFERRED_GRADE
, PL.OKE_CONTRACT_HEADER_ID
, PL.OKE_CONTRACT_VERSION_ID
FROM PO_LINES_ALL PL
, PO_HEADERS_ALL PH
, PO_LINE_TYPES LT
, HR_ALL_ORGANIZATION_UNITS OP
WHERE PH.TYPE_LOOKUP_CODE = 'PLANNED'
AND PL.PO_HEADER_ID = PH.PO_HEADER_ID
AND PL.ORG_ID = OP.ORGANIZATION_ID
AND PL.LINE_TYPE_ID = LT.LINE_TYPE_ID(+)
AND '_SEC:PL.ORG_ID' IS NOT NULL WITH READ ONLY