VIEW: APPS.POBV_PO_LINES

Source

View Text - Preformatted

SELECT PL.PO_LINE_ID, PL.LINE_NUM, PL.PO_HEADER_ID, PH.SEGMENT1, PL.ORG_ID, OP.NAME, '_LA:ph.TYPE_LOOKUP_CODE:PO_LOOKUP_CODES:DOCUMENT SUBTYPE:DISPLAYED_FIELD', 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.PRICE_BREAK_LOOKUP_CODE:PO_LOOKUP_CODES:PRICE BREAK TYPE:DISPLAYED_FIELD', PL.COMMITTED_AMOUNT, PL.QUANTITY_COMMITTED, '_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.EXPIRATION_DATE, PL.USSGL_TRANSACTION_CODE, PL.ITEM_ID, PL.ITEM_REVISION, PL.CATEGORY_ID, PL.UNIT_MEAS_LOOKUP_CODE, PL.CONTRACT_NUM, 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.AUCTION_DISPLAY_NUMBER, PL.AUCTION_HEADER_ID, PL.AUCTION_LINE_NUMBER, PL.BID_NUMBER, PL.BID_LINE_NUMBER, PL.RETROACTIVE_DATE, PL.OKE_CONTRACT_HEADER_ID, PL.OKE_CONTRACT_VERSION_ID, PL.SUPPLIER_REF_NUMBER, PL.CONTRACT_ID, PL.SVC_AMOUNT_NOTIF_SENT, PL.SVC_COMPLETION_NOTIF_SENT, PL.BASE_UNIT_PRICE, PL.JOB_ID, PL.AMOUNT, PL.PURCHASE_BASIS, PL.MATCHING_BASIS, PL.ORDER_TYPE_LOOKUP_CODE, PL.MANUAL_PRICE_CHANGE_FLAG, PL.RETAINAGE_RATE, PL.MAX_RETAINAGE_AMOUNT, PL.PROGRESS_PAYMENT_RATE, PL.RECOUPMENT_RATE, PL.TAX_ATTRIBUTE_UPDATE_CODE FROM PO_LINES_ALL PL, PO_HEADERS_ALL PH, PO_LINE_TYPES LT, HR_ALL_ORGANIZATION_UNITS OP WHERE PL.PO_HEADER_ID = PH.PO_HEADER_ID AND PL.ORG_ID = OP.ORGANIZATION_ID AND PL.LINE_TYPE_ID = LT.LINE_TYPE_ID(+) WITH READ ONLY

View Text - HTML Formatted

SELECT PL.PO_LINE_ID
, PL.LINE_NUM
, PL.PO_HEADER_ID
, PH.SEGMENT1
, PL.ORG_ID
, OP.NAME
, '_LA:PH.TYPE_LOOKUP_CODE:PO_LOOKUP_CODES:DOCUMENT SUBTYPE:DISPLAYED_FIELD'
, 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.PRICE_BREAK_LOOKUP_CODE:PO_LOOKUP_CODES:PRICE BREAK TYPE:DISPLAYED_FIELD'
, PL.COMMITTED_AMOUNT
, PL.QUANTITY_COMMITTED
, '_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.EXPIRATION_DATE
, PL.USSGL_TRANSACTION_CODE
, PL.ITEM_ID
, PL.ITEM_REVISION
, PL.CATEGORY_ID
, PL.UNIT_MEAS_LOOKUP_CODE
, PL.CONTRACT_NUM
, 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.AUCTION_DISPLAY_NUMBER
, PL.AUCTION_HEADER_ID
, PL.AUCTION_LINE_NUMBER
, PL.BID_NUMBER
, PL.BID_LINE_NUMBER
, PL.RETROACTIVE_DATE
, PL.OKE_CONTRACT_HEADER_ID
, PL.OKE_CONTRACT_VERSION_ID
, PL.SUPPLIER_REF_NUMBER
, PL.CONTRACT_ID
, PL.SVC_AMOUNT_NOTIF_SENT
, PL.SVC_COMPLETION_NOTIF_SENT
, PL.BASE_UNIT_PRICE
, PL.JOB_ID
, PL.AMOUNT
, PL.PURCHASE_BASIS
, PL.MATCHING_BASIS
, PL.ORDER_TYPE_LOOKUP_CODE
, PL.MANUAL_PRICE_CHANGE_FLAG
, PL.RETAINAGE_RATE
, PL.MAX_RETAINAGE_AMOUNT
, PL.PROGRESS_PAYMENT_RATE
, PL.RECOUPMENT_RATE
, PL.TAX_ATTRIBUTE_UPDATE_CODE
FROM PO_LINES_ALL PL
, PO_HEADERS_ALL PH
, PO_LINE_TYPES LT
, HR_ALL_ORGANIZATION_UNITS OP
WHERE PL.PO_HEADER_ID = PH.PO_HEADER_ID
AND PL.ORG_ID = OP.ORGANIZATION_ID
AND PL.LINE_TYPE_ID = LT.LINE_TYPE_ID(+) WITH READ ONLY