VIEW: IGC.IGC_CC_ARC_PO_LINE_LOC_ALL#

Source

View Text - Preformatted

select LINE_LOCATION_ID LINE_LOCATION_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, PO_HEADER_ID PO_HEADER_ID, PO_LINE_ID PO_LINE_ID, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, QUANTITY QUANTITY, QUANTITY_RECEIVED QUANTITY_RECEIVED, QUANTITY_ACCEPTED QUANTITY_ACCEPTED, QUANTITY_REJECTED QUANTITY_REJECTED, QUANTITY_BILLED QUANTITY_BILLED, QUANTITY_CANCELLED QUANTITY_CANCELLED, UNIT_MEAS_LOOKUP_CODE UNIT_MEAS_LOOKUP_CODE, PO_RELEASE_ID PO_RELEASE_ID, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID, SHIP_VIA_LOOKUP_CODE SHIP_VIA_LOOKUP_CODE, NEED_BY_DATE NEED_BY_DATE, PROMISED_DATE PROMISED_DATE, LAST_ACCEPT_DATE LAST_ACCEPT_DATE, PRICE_OVERRIDE PRICE_OVERRIDE, ENCUMBERED_FLAG ENCUMBERED_FLAG, ENCUMBERED_DATE ENCUMBERED_DATE, UNENCUMBERED_QUANTITY UNENCUMBERED_QUANTITY, FOB_LOOKUP_CODE FOB_LOOKUP_CODE, FREIGHT_TERMS_LOOKUP_CODE FREIGHT_TERMS_LOOKUP_CODE, TAXABLE_FLAG TAXABLE_FLAG, TAX_NAME TAX_NAME, ESTIMATED_TAX_AMOUNT ESTIMATED_TAX_AMOUNT, FROM_HEADER_ID FROM_HEADER_ID, FROM_LINE_ID FROM_LINE_ID, FROM_LINE_LOCATION_ID FROM_LINE_LOCATION_ID, START_DATE START_DATE, END_DATE END_DATE, LEAD_TIME LEAD_TIME, LEAD_TIME_UNIT LEAD_TIME_UNIT, PRICE_DISCOUNT PRICE_DISCOUNT, TERMS_ID TERMS_ID, APPROVED_FLAG APPROVED_FLAG, APPROVED_DATE APPROVED_DATE, CLOSED_FLAG CLOSED_FLAG, CANCEL_FLAG CANCEL_FLAG, CANCELLED_BY CANCELLED_BY, CANCEL_DATE CANCEL_DATE, CANCEL_REASON CANCEL_REASON, FIRM_STATUS_LOOKUP_CODE FIRM_STATUS_LOOKUP_CODE, FIRM_DATE FIRM_DATE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, UNIT_OF_MEASURE_CLASS UNIT_OF_MEASURE_CLASS, ENCUMBER_NOW ENCUMBER_NOW, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, INSPECTION_REQUIRED_FLAG INSPECTION_REQUIRED_FLAG, RECEIPT_REQUIRED_FLAG RECEIPT_REQUIRED_FLAG, QTY_RCV_TOLERANCE QTY_RCV_TOLERANCE, QTY_RCV_EXCEPTION_CODE QTY_RCV_EXCEPTION_CODE, ENFORCE_SHIP_TO_LOCATION_CODE ENFORCE_SHIP_TO_LOCATION_CODE, ALLOW_SUBSTITUTE_RECEIPTS_FLAG ALLOW_SUBSTITUTE_RECEIPTS_FLAG, DAYS_EARLY_RECEIPT_ALLOWED DAYS_EARLY_RECEIPT_ALLOWED, DAYS_LATE_RECEIPT_ALLOWED DAYS_LATE_RECEIPT_ALLOWED, RECEIPT_DAYS_EXCEPTION_CODE RECEIPT_DAYS_EXCEPTION_CODE, INVOICE_CLOSE_TOLERANCE INVOICE_CLOSE_TOLERANCE, RECEIVE_CLOSE_TOLERANCE RECEIVE_CLOSE_TOLERANCE, SHIP_TO_ORGANIZATION_ID SHIP_TO_ORGANIZATION_ID, SHIPMENT_NUM SHIPMENT_NUM, SOURCE_SHIPMENT_ID SOURCE_SHIPMENT_ID, SHIPMENT_TYPE SHIPMENT_TYPE, CLOSED_CODE CLOSED_CODE, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE, GOVERNMENT_CONTEXT GOVERNMENT_CONTEXT, RECEIVING_ROUTING_ID RECEIVING_ROUTING_ID, ACCRUE_ON_RECEIPT_FLAG ACCRUE_ON_RECEIPT_FLAG, CLOSED_REASON CLOSED_REASON, CLOSED_DATE CLOSED_DATE, CLOSED_BY CLOSED_BY, ORG_ID ORG_ID, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY, QUANTITY_SHIPPED QUANTITY_SHIPPED, COUNTRY_OF_ORIGIN_CODE COUNTRY_OF_ORIGIN_CODE, TAX_USER_OVERRIDE_FLAG TAX_USER_OVERRIDE_FLAG, MATCH_FLAG MATCH_FLAG, MATCH_OPTION MATCH_OPTION, TAX_CODE_ID TAX_CODE_ID, CALCULATE_TAX_FLAG CALCULATE_TAX_FLAG, CHANGE_PROMISED_DATE_REASON CHANGE_PROMISED_DATE_REASON from "IGC"."IGC_CC_ARC_PO_LINE_LOC_ALL"

View Text - HTML Formatted

SELECT LINE_LOCATION_ID LINE_LOCATION_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, PO_HEADER_ID PO_HEADER_ID
, PO_LINE_ID PO_LINE_ID
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, QUANTITY QUANTITY
, QUANTITY_RECEIVED QUANTITY_RECEIVED
, QUANTITY_ACCEPTED QUANTITY_ACCEPTED
, QUANTITY_REJECTED QUANTITY_REJECTED
, QUANTITY_BILLED QUANTITY_BILLED
, QUANTITY_CANCELLED QUANTITY_CANCELLED
, UNIT_MEAS_LOOKUP_CODE UNIT_MEAS_LOOKUP_CODE
, PO_RELEASE_ID PO_RELEASE_ID
, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, SHIP_VIA_LOOKUP_CODE SHIP_VIA_LOOKUP_CODE
, NEED_BY_DATE NEED_BY_DATE
, PROMISED_DATE PROMISED_DATE
, LAST_ACCEPT_DATE LAST_ACCEPT_DATE
, PRICE_OVERRIDE PRICE_OVERRIDE
, ENCUMBERED_FLAG ENCUMBERED_FLAG
, ENCUMBERED_DATE ENCUMBERED_DATE
, UNENCUMBERED_QUANTITY UNENCUMBERED_QUANTITY
, FOB_LOOKUP_CODE FOB_LOOKUP_CODE
, FREIGHT_TERMS_LOOKUP_CODE FREIGHT_TERMS_LOOKUP_CODE
, TAXABLE_FLAG TAXABLE_FLAG
, TAX_NAME TAX_NAME
, ESTIMATED_TAX_AMOUNT ESTIMATED_TAX_AMOUNT
, FROM_HEADER_ID FROM_HEADER_ID
, FROM_LINE_ID FROM_LINE_ID
, FROM_LINE_LOCATION_ID FROM_LINE_LOCATION_ID
, START_DATE START_DATE
, END_DATE END_DATE
, LEAD_TIME LEAD_TIME
, LEAD_TIME_UNIT LEAD_TIME_UNIT
, PRICE_DISCOUNT PRICE_DISCOUNT
, TERMS_ID TERMS_ID
, APPROVED_FLAG APPROVED_FLAG
, APPROVED_DATE APPROVED_DATE
, CLOSED_FLAG CLOSED_FLAG
, CANCEL_FLAG CANCEL_FLAG
, CANCELLED_BY CANCELLED_BY
, CANCEL_DATE CANCEL_DATE
, CANCEL_REASON CANCEL_REASON
, FIRM_STATUS_LOOKUP_CODE FIRM_STATUS_LOOKUP_CODE
, FIRM_DATE FIRM_DATE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, UNIT_OF_MEASURE_CLASS UNIT_OF_MEASURE_CLASS
, ENCUMBER_NOW ENCUMBER_NOW
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, INSPECTION_REQUIRED_FLAG INSPECTION_REQUIRED_FLAG
, RECEIPT_REQUIRED_FLAG RECEIPT_REQUIRED_FLAG
, QTY_RCV_TOLERANCE QTY_RCV_TOLERANCE
, QTY_RCV_EXCEPTION_CODE QTY_RCV_EXCEPTION_CODE
, ENFORCE_SHIP_TO_LOCATION_CODE ENFORCE_SHIP_TO_LOCATION_CODE
, ALLOW_SUBSTITUTE_RECEIPTS_FLAG ALLOW_SUBSTITUTE_RECEIPTS_FLAG
, DAYS_EARLY_RECEIPT_ALLOWED DAYS_EARLY_RECEIPT_ALLOWED
, DAYS_LATE_RECEIPT_ALLOWED DAYS_LATE_RECEIPT_ALLOWED
, RECEIPT_DAYS_EXCEPTION_CODE RECEIPT_DAYS_EXCEPTION_CODE
, INVOICE_CLOSE_TOLERANCE INVOICE_CLOSE_TOLERANCE
, RECEIVE_CLOSE_TOLERANCE RECEIVE_CLOSE_TOLERANCE
, SHIP_TO_ORGANIZATION_ID SHIP_TO_ORGANIZATION_ID
, SHIPMENT_NUM SHIPMENT_NUM
, SOURCE_SHIPMENT_ID SOURCE_SHIPMENT_ID
, SHIPMENT_TYPE SHIPMENT_TYPE
, CLOSED_CODE CLOSED_CODE
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, GOVERNMENT_CONTEXT GOVERNMENT_CONTEXT
, RECEIVING_ROUTING_ID RECEIVING_ROUTING_ID
, ACCRUE_ON_RECEIPT_FLAG ACCRUE_ON_RECEIPT_FLAG
, CLOSED_REASON CLOSED_REASON
, CLOSED_DATE CLOSED_DATE
, CLOSED_BY CLOSED_BY
, ORG_ID ORG_ID
, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, QUANTITY_SHIPPED QUANTITY_SHIPPED
, COUNTRY_OF_ORIGIN_CODE COUNTRY_OF_ORIGIN_CODE
, TAX_USER_OVERRIDE_FLAG TAX_USER_OVERRIDE_FLAG
, MATCH_FLAG MATCH_FLAG
, MATCH_OPTION MATCH_OPTION
, TAX_CODE_ID TAX_CODE_ID
, CALCULATE_TAX_FLAG CALCULATE_TAX_FLAG
, CHANGE_PROMISED_DATE_REASON CHANGE_PROMISED_DATE_REASON
FROM "IGC"."IGC_CC_ARC_PO_LINE_LOC_ALL"