VIEW: APPS.PO_LINE_LOCATIONS_TRX_V

Source

View Text - Preformatted

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 EXISTS (SELECT 1 FROM po_distributions_all pod WHERE pod.line_location_id = poll.line_location_id) AND PO_CLM_INTG_GRP.Hide_Nonfunded ( 'PO' ,poll.PO_HEADER_ID ,poll.PO_LINE_ID ,poll.LINE_LOCATION_ID ,NULL) <> 'Y'

View Text - HTML Formatted

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 EXISTS (SELECT 1
FROM PO_DISTRIBUTIONS_ALL POD
WHERE POD.LINE_LOCATION_ID = POLL.LINE_LOCATION_ID)
AND PO_CLM_INTG_GRP.HIDE_NONFUNDED ( 'PO'
, POLL.PO_HEADER_ID
, POLL.PO_LINE_ID
, POLL.LINE_LOCATION_ID
, NULL) <> 'Y'