VIEW: IGC.IGC_CC_ARC_PO_HEADERS_ALL#

Source

View Text - Preformatted

select PO_HEADER_ID PO_HEADER_ID, AGENT_ID AGENT_ID, TYPE_LOOKUP_CODE TYPE_LOOKUP_CODE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, SEGMENT1 SEGMENT1, SUMMARY_FLAG SUMMARY_FLAG, ENABLED_FLAG ENABLED_FLAG, SEGMENT2 SEGMENT2, SEGMENT3 SEGMENT3, SEGMENT4 SEGMENT4, SEGMENT5 SEGMENT5, START_DATE_ACTIVE START_DATE_ACTIVE, END_DATE_ACTIVE END_DATE_ACTIVE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, VENDOR_ID VENDOR_ID, VENDOR_SITE_ID VENDOR_SITE_ID, VENDOR_CONTACT_ID VENDOR_CONTACT_ID, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID, BILL_TO_LOCATION_ID BILL_TO_LOCATION_ID, TERMS_ID TERMS_ID, SHIP_VIA_LOOKUP_CODE SHIP_VIA_LOOKUP_CODE, FOB_LOOKUP_CODE FOB_LOOKUP_CODE, FREIGHT_TERMS_LOOKUP_CODE FREIGHT_TERMS_LOOKUP_CODE, STATUS_LOOKUP_CODE STATUS_LOOKUP_CODE, CURRENCY_CODE CURRENCY_CODE, RATE_TYPE RATE_TYPE, RATE_DATE RATE_DATE, RATE RATE, FROM_HEADER_ID FROM_HEADER_ID, FROM_TYPE_LOOKUP_CODE FROM_TYPE_LOOKUP_CODE, START_DATE START_DATE, END_DATE END_DATE, BLANKET_TOTAL_AMOUNT BLANKET_TOTAL_AMOUNT, AUTHORIZATION_STATUS AUTHORIZATION_STATUS, REVISION_NUM REVISION_NUM, REVISED_DATE REVISED_DATE, APPROVED_FLAG APPROVED_FLAG, APPROVED_DATE APPROVED_DATE, AMOUNT_LIMIT AMOUNT_LIMIT, MIN_RELEASE_AMOUNT MIN_RELEASE_AMOUNT, NOTE_TO_AUTHORIZER NOTE_TO_AUTHORIZER, NOTE_TO_VENDOR NOTE_TO_VENDOR, NOTE_TO_RECEIVER NOTE_TO_RECEIVER, PRINT_COUNT PRINT_COUNT, PRINTED_DATE PRINTED_DATE, VENDOR_ORDER_NUM VENDOR_ORDER_NUM, CONFIRMING_ORDER_FLAG CONFIRMING_ORDER_FLAG, COMMENTS COMMENTS, REPLY_DATE REPLY_DATE, REPLY_METHOD_LOOKUP_CODE REPLY_METHOD_LOOKUP_CODE, RFQ_CLOSE_DATE RFQ_CLOSE_DATE, QUOTE_TYPE_LOOKUP_CODE QUOTE_TYPE_LOOKUP_CODE, QUOTATION_CLASS_CODE QUOTATION_CLASS_CODE, QUOTE_WARNING_DELAY_UNIT QUOTE_WARNING_DELAY_UNIT, QUOTE_WARNING_DELAY QUOTE_WARNING_DELAY, QUOTE_VENDOR_QUOTE_NUMBER QUOTE_VENDOR_QUOTE_NUMBER, ACCEPTANCE_REQUIRED_FLAG ACCEPTANCE_REQUIRED_FLAG, ACCEPTANCE_DUE_DATE ACCEPTANCE_DUE_DATE, CLOSED_DATE CLOSED_DATE, USER_HOLD_FLAG USER_HOLD_FLAG, APPROVAL_REQUIRED_FLAG APPROVAL_REQUIRED_FLAG, CANCEL_FLAG CANCEL_FLAG, FIRM_STATUS_LOOKUP_CODE FIRM_STATUS_LOOKUP_CODE, FIRM_DATE FIRM_DATE, FROZEN_FLAG FROZEN_FLAG, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, CLOSED_CODE CLOSED_CODE, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE, GOVERNMENT_CONTEXT GOVERNMENT_CONTEXT, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, ORG_ID ORG_ID, SUPPLY_AGREEMENT_FLAG SUPPLY_AGREEMENT_FLAG, EDI_PROCESSED_FLAG EDI_PROCESSED_FLAG, EDI_PROCESSED_STATUS EDI_PROCESSED_STATUS, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY, 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, INTERFACE_SOURCE_CODE INTERFACE_SOURCE_CODE, REFERENCE_NUM REFERENCE_NUM, WF_ITEM_TYPE WF_ITEM_TYPE, WF_ITEM_KEY WF_ITEM_KEY, MRC_RATE_TYPE MRC_RATE_TYPE, MRC_RATE_DATE MRC_RATE_DATE, MRC_RATE MRC_RATE, PCARD_ID PCARD_ID, PRICE_UPDATE_TOLERANCE PRICE_UPDATE_TOLERANCE, PAY_ON_CODE PAY_ON_CODE from "IGC"."IGC_CC_ARC_PO_HEADERS_ALL"

View Text - HTML Formatted

SELECT PO_HEADER_ID PO_HEADER_ID
, AGENT_ID AGENT_ID
, TYPE_LOOKUP_CODE TYPE_LOOKUP_CODE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, SEGMENT1 SEGMENT1
, SUMMARY_FLAG SUMMARY_FLAG
, ENABLED_FLAG ENABLED_FLAG
, SEGMENT2 SEGMENT2
, SEGMENT3 SEGMENT3
, SEGMENT4 SEGMENT4
, SEGMENT5 SEGMENT5
, START_DATE_ACTIVE START_DATE_ACTIVE
, END_DATE_ACTIVE END_DATE_ACTIVE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, VENDOR_ID VENDOR_ID
, VENDOR_SITE_ID VENDOR_SITE_ID
, VENDOR_CONTACT_ID VENDOR_CONTACT_ID
, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, BILL_TO_LOCATION_ID BILL_TO_LOCATION_ID
, TERMS_ID TERMS_ID
, SHIP_VIA_LOOKUP_CODE SHIP_VIA_LOOKUP_CODE
, FOB_LOOKUP_CODE FOB_LOOKUP_CODE
, FREIGHT_TERMS_LOOKUP_CODE FREIGHT_TERMS_LOOKUP_CODE
, STATUS_LOOKUP_CODE STATUS_LOOKUP_CODE
, CURRENCY_CODE CURRENCY_CODE
, RATE_TYPE RATE_TYPE
, RATE_DATE RATE_DATE
, RATE RATE
, FROM_HEADER_ID FROM_HEADER_ID
, FROM_TYPE_LOOKUP_CODE FROM_TYPE_LOOKUP_CODE
, START_DATE START_DATE
, END_DATE END_DATE
, BLANKET_TOTAL_AMOUNT BLANKET_TOTAL_AMOUNT
, AUTHORIZATION_STATUS AUTHORIZATION_STATUS
, REVISION_NUM REVISION_NUM
, REVISED_DATE REVISED_DATE
, APPROVED_FLAG APPROVED_FLAG
, APPROVED_DATE APPROVED_DATE
, AMOUNT_LIMIT AMOUNT_LIMIT
, MIN_RELEASE_AMOUNT MIN_RELEASE_AMOUNT
, NOTE_TO_AUTHORIZER NOTE_TO_AUTHORIZER
, NOTE_TO_VENDOR NOTE_TO_VENDOR
, NOTE_TO_RECEIVER NOTE_TO_RECEIVER
, PRINT_COUNT PRINT_COUNT
, PRINTED_DATE PRINTED_DATE
, VENDOR_ORDER_NUM VENDOR_ORDER_NUM
, CONFIRMING_ORDER_FLAG CONFIRMING_ORDER_FLAG
, COMMENTS COMMENTS
, REPLY_DATE REPLY_DATE
, REPLY_METHOD_LOOKUP_CODE REPLY_METHOD_LOOKUP_CODE
, RFQ_CLOSE_DATE RFQ_CLOSE_DATE
, QUOTE_TYPE_LOOKUP_CODE QUOTE_TYPE_LOOKUP_CODE
, QUOTATION_CLASS_CODE QUOTATION_CLASS_CODE
, QUOTE_WARNING_DELAY_UNIT QUOTE_WARNING_DELAY_UNIT
, QUOTE_WARNING_DELAY QUOTE_WARNING_DELAY
, QUOTE_VENDOR_QUOTE_NUMBER QUOTE_VENDOR_QUOTE_NUMBER
, ACCEPTANCE_REQUIRED_FLAG ACCEPTANCE_REQUIRED_FLAG
, ACCEPTANCE_DUE_DATE ACCEPTANCE_DUE_DATE
, CLOSED_DATE CLOSED_DATE
, USER_HOLD_FLAG USER_HOLD_FLAG
, APPROVAL_REQUIRED_FLAG APPROVAL_REQUIRED_FLAG
, CANCEL_FLAG CANCEL_FLAG
, FIRM_STATUS_LOOKUP_CODE FIRM_STATUS_LOOKUP_CODE
, FIRM_DATE FIRM_DATE
, FROZEN_FLAG FROZEN_FLAG
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, CLOSED_CODE CLOSED_CODE
, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, GOVERNMENT_CONTEXT GOVERNMENT_CONTEXT
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ORG_ID ORG_ID
, SUPPLY_AGREEMENT_FLAG SUPPLY_AGREEMENT_FLAG
, EDI_PROCESSED_FLAG EDI_PROCESSED_FLAG
, EDI_PROCESSED_STATUS EDI_PROCESSED_STATUS
, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, 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
, INTERFACE_SOURCE_CODE INTERFACE_SOURCE_CODE
, REFERENCE_NUM REFERENCE_NUM
, WF_ITEM_TYPE WF_ITEM_TYPE
, WF_ITEM_KEY WF_ITEM_KEY
, MRC_RATE_TYPE MRC_RATE_TYPE
, MRC_RATE_DATE MRC_RATE_DATE
, MRC_RATE MRC_RATE
, PCARD_ID PCARD_ID
, PRICE_UPDATE_TOLERANCE PRICE_UPDATE_TOLERANCE
, PAY_ON_CODE PAY_ON_CODE
FROM "IGC"."IGC_CC_ARC_PO_HEADERS_ALL"