Product: | PO - Purchasing |
---|---|
Description: | View on po_line_locations table. |
Implementation/DBA Data: | APPS.PO_LINE_LOCATIONS_TRX_V |
SELECT POLL.LINE_LOCATION_ID
, POLL.LAST_UPDATE_DATE
, POLL.LAST_UPDATED_BY
, POLL.PO_HEADER_ID
, POLL.PO_LINE_ID
, POLL.LAST_UPDATE_LOGIN
, POLL.CREATION_DATE
, POLL.CREATED_BY
, POLL.QUANTITY
, POLL.QUANTITY_RECEIVED
, POLL.QUANTITY_ACCEPTED
, POLL.QUANTITY_REJECTED
, POLL.QUANTITY_BILLED
, POLL.QUANTITY_CANCELLED
, POLL.UNIT_MEAS_LOOKUP_CODE
, POLL.PO_RELEASE_ID
, POLL.SHIP_TO_LOCATION_ID
, POLL.SHIP_VIA_LOOKUP_CODE
, POLL.NEED_BY_DATE
, POLL.PROMISED_DATE
, POLL.LAST_ACCEPT_DATE
, POLL.PRICE_OVERRIDE
, POLL.ENCUMBERED_FLAG
, POLL.ENCUMBERED_DATE
, POLL.UNENCUMBERED_QUANTITY
, POLL.FOB_LOOKUP_CODE
, POLL.FREIGHT_TERMS_LOOKUP_CODE
, POLL.TAXABLE_FLAG
, POLL.TAX_NAME
, POLL.ESTIMATED_TAX_AMOUNT
, POLL.FROM_HEADER_ID
, POLL.FROM_LINE_ID
, POLL.FROM_LINE_LOCATION_ID
, POLL.START_DATE
, POLL.END_DATE
, POLL.LEAD_TIME
, POLL.LEAD_TIME_UNIT
, POLL.PRICE_DISCOUNT
, POLL.TERMS_ID
, POLL.APPROVED_FLAG
, POLL.APPROVED_DATE
, POLL.CLOSED_FLAG
, POLL.CANCEL_FLAG
, POLL.CANCELLED_BY
, POLL.CANCEL_DATE
, POLL.CANCEL_REASON
, POLL.FIRM_STATUS_LOOKUP_CODE
, POLL.FIRM_DATE
, POLL.ATTRIBUTE_CATEGORY
, POLL.ATTRIBUTE1
, POLL.ATTRIBUTE2
, POLL.ATTRIBUTE3
, POLL.ATTRIBUTE4
, POLL.ATTRIBUTE5
, POLL.ATTRIBUTE6
, POLL.ATTRIBUTE7
, POLL.ATTRIBUTE8
, POLL.ATTRIBUTE9
, POLL.ATTRIBUTE10
, POLL.UNIT_OF_MEASURE_CLASS
, POLL.ENCUMBER_NOW
, POLL.ATTRIBUTE11
, POLL.ATTRIBUTE12
, POLL.ATTRIBUTE13
, POLL.ATTRIBUTE14
, POLL.ATTRIBUTE15
, POLL.INSPECTION_REQUIRED_FLAG
, POLL.RECEIPT_REQUIRED_FLAG
, POLL.QTY_RCV_TOLERANCE
, POLL.QTY_RCV_EXCEPTION_CODE
, POLL.ENFORCE_SHIP_TO_LOCATION_CODE
, POLL.ALLOW_SUBSTITUTE_RECEIPTS_FLAG
, POLL.DAYS_EARLY_RECEIPT_ALLOWED
, POLL.DAYS_LATE_RECEIPT_ALLOWED
, POLL.RECEIPT_DAYS_EXCEPTION_CODE
, POLL.INVOICE_CLOSE_TOLERANCE
, POLL.RECEIVE_CLOSE_TOLERANCE
, POLL.SHIP_TO_ORGANIZATION_ID
, POLL.SHIPMENT_NUM
, POLL.SOURCE_SHIPMENT_ID
, POLL.SHIPMENT_TYPE
, POLL.CLOSED_CODE
, POLL.REQUEST_ID
, POLL.PROGRAM_APPLICATION_ID
, POLL.PROGRAM_ID
, POLL.PROGRAM_UPDATE_DATE
, POLL.USSGL_TRANSACTION_CODE
, POLL.GOVERNMENT_CONTEXT
, POLL.RECEIVING_ROUTING_ID
, POLL.ACCRUE_ON_RECEIPT_FLAG
, POLL.CLOSED_REASON
, POLL.CLOSED_DATE
, POLL.CLOSED_BY
, POLL.ORG_ID
, POLL.QUANTITY_SHIPPED
, POLL.GLOBAL_ATTRIBUTE_CATEGORY
, POLL.GLOBAL_ATTRIBUTE1
, POLL.GLOBAL_ATTRIBUTE2
, POLL.GLOBAL_ATTRIBUTE3
, POLL.GLOBAL_ATTRIBUTE4
, POLL.GLOBAL_ATTRIBUTE5
, POLL.GLOBAL_ATTRIBUTE6
, POLL.GLOBAL_ATTRIBUTE7
, POLL.GLOBAL_ATTRIBUTE8
, POLL.GLOBAL_ATTRIBUTE9
, POLL.GLOBAL_ATTRIBUTE10
, POLL.GLOBAL_ATTRIBUTE11
, POLL.GLOBAL_ATTRIBUTE12
, POLL.GLOBAL_ATTRIBUTE13
, POLL.GLOBAL_ATTRIBUTE14
, POLL.GLOBAL_ATTRIBUTE15
, POLL.GLOBAL_ATTRIBUTE16
, POLL.GLOBAL_ATTRIBUTE17
, POLL.GLOBAL_ATTRIBUTE18
, POLL.GLOBAL_ATTRIBUTE19
, POLL.GLOBAL_ATTRIBUTE20
, POLL.COUNTRY_OF_ORIGIN_CODE
, POLL.TAX_USER_OVERRIDE_FLAG
, POLL.MATCH_OPTION
, POLL.TAX_CODE_ID
, POLL.CALCULATE_TAX_FLAG
, POLL.CHANGE_PROMISED_DATE_REASON
, POLL.NOTE_TO_RECEIVER
, POLL.SECONDARY_QUANTITY
, POLL.SECONDARY_UNIT_OF_MEASURE
, POLL.PREFERRED_GRADE
, POLL.SECONDARY_QUANTITY_RECEIVED
, POLL.SECONDARY_QUANTITY_ACCEPTED
, POLL.SECONDARY_QUANTITY_REJECTED
, POLL.SECONDARY_QUANTITY_CANCELLED
, POLL.SECONDARY_QUANTITY_SHIPPED
, POLL.VMI_FLAG
, POLL.CONSIGNED_FLAG
, POLL.RETROACTIVE_DATE
, POLL.SUPPLIER_ORDER_LINE_NUMBER
, POLL.AMOUNT
, POLL.AMOUNT_RECEIVED
, POLL.AMOUNT_BILLED
, POLL.AMOUNT_CANCELLED
, POLL.AMOUNT_REJECTED
, POLL.AMOUNT_ACCEPTED
, POLL.DROP_SHIP_FLAG
, POLL.SALES_ORDER_UPDATE_DATE
, POLL.TRANSACTION_FLOW_HEADER_ID
, POLL.FINAL_MATCH_FLAG
, POLL.MANUAL_PRICE_CHANGE_FLAG
, POLL.SHIPMENT_CLOSED_DATE
, POLL.CLOSED_FOR_RECEIVING_DATE
, POLL.CLOSED_FOR_INVOICE_DATE
, POLL.VALUE_BASIS
, POLL.MATCHING_BASIS
, POLL.PAYMENT_TYPE
, POLL.DESCRIPTION
, POLL.WORK_APPROVER_ID
, POLL.BID_PAYMENT_ID
, POLL.QUANTITY_FINANCED
, POLL.AMOUNT_FINANCED
, POLL.QUANTITY_RECOUPED
, POLL.AMOUNT_RECOUPED
, POLL.RETAINAGE_WITHHELD_AMOUNT
, POLL.RETAINAGE_RELEASED_AMOUNT
, POLL.AMOUNT_SHIPPED
, POLL.OUTSOURCED_ASSEMBLY
, POLL.TAX_ATTRIBUTE_UPDATE_CODE
, POLL.ORIGINAL_SHIPMENT_ID
, POLL.LCM_FLAG
, POLL.UDA_TEMPLATE_ID
, POLL.DRAFT_ID
, POLL.CLM_PERIOD_PERF_END_DATE
, POLL.CLM_PERIOD_PERF_START_DATE
FROM PO_LINE_LOCATIONS POLL
, PO_LINES_TRX_V PLTV
WHERE POLL.PO_LINE_ID = PLTV.PO_LINE_ID
AND PO_CLM_INTG_GRP.HIDE_NONFUNDED ( 'PO'
, POLL.PO_HEADER_ID
, POLL.PO_LINE_ID
, POLL.LINE_LOCATION_ID
, NULL) <> 'Y'