VIEW: PO.PO_REQUISITION_HEADERS_ALL#

Source

View Text - Preformatted

select REQUISITION_HEADER_ID REQUISITION_HEADER_ID, PREPARER_ID PREPARER_ID, 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, DESCRIPTION DESCRIPTION, AUTHORIZATION_STATUS AUTHORIZATION_STATUS, NOTE_TO_AUTHORIZER NOTE_TO_AUTHORIZER, TYPE_LOOKUP_CODE TYPE_LOOKUP_CODE, TRANSFERRED_TO_OE_FLAG TRANSFERRED_TO_OE_FLAG, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ON_LINE_FLAG ON_LINE_FLAG, PRELIMINARY_RESEARCH_FLAG PRELIMINARY_RESEARCH_FLAG, RESEARCH_COMPLETE_FLAG RESEARCH_COMPLETE_FLAG, PREPARER_FINISHED_FLAG PREPARER_FINISHED_FLAG, PREPARER_FINISHED_DATE PREPARER_FINISHED_DATE, AGENT_RETURN_FLAG AGENT_RETURN_FLAG, AGENT_RETURN_NOTE AGENT_RETURN_NOTE, CANCEL_FLAG CANCEL_FLAG, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, 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, INTERFACE_SOURCE_CODE INTERFACE_SOURCE_CODE, INTERFACE_SOURCE_LINE_ID INTERFACE_SOURCE_LINE_ID, CLOSED_CODE CLOSED_CODE, ORG_ID ORG_ID, WF_ITEM_TYPE WF_ITEM_TYPE, WF_ITEM_KEY WF_ITEM_KEY, EMERGENCY_PO_NUM EMERGENCY_PO_NUM, PCARD_ID PCARD_ID, APPS_SOURCE_CODE APPS_SOURCE_CODE, CBC_ACCOUNTING_DATE CBC_ACCOUNTING_DATE, CHANGE_PENDING_FLAG CHANGE_PENDING_FLAG, ACTIVE_SHOPPING_CART_FLAG ACTIVE_SHOPPING_CART_FLAG, CONTRACTOR_STATUS CONTRACTOR_STATUS, CONTRACTOR_REQUISITION_FLAG CONTRACTOR_REQUISITION_FLAG, SUPPLIER_NOTIFIED_FLAG SUPPLIER_NOTIFIED_FLAG, EMERGENCY_PO_ORG_ID EMERGENCY_PO_ORG_ID, APPROVED_DATE APPROVED_DATE, TAX_ATTRIBUTE_UPDATE_CODE TAX_ATTRIBUTE_UPDATE_CODE, FIRST_APPROVER_ID FIRST_APPROVER_ID, FIRST_POSITION_ID FIRST_POSITION_ID, FEDERAL_FLAG FEDERAL_FLAG, CONFORMED_HEADER_ID CONFORMED_HEADER_ID, REVISION_NUM REVISION_NUM, AMENDMENT_TYPE AMENDMENT_TYPE, AMENDMENT_STATUS AMENDMENT_STATUS, AMENDMENT_REASON AMENDMENT_REASON, UDA_TEMPLATE_ID UDA_TEMPLATE_ID, UDA_TEMPLATE_DATE UDA_TEMPLATE_DATE, CLM_ISSUING_OFFICE CLM_ISSUING_OFFICE, CLM_COTR_OFFICE CLM_COTR_OFFICE, CLM_COTR_CONTACT CLM_COTR_CONTACT, CLM_PRIORITY_CODE CLM_PRIORITY_CODE, SUGGESTED_AWARD_NO SUGGESTED_AWARD_NO, CLM_ASSIST_OFFICE CLM_ASSIST_OFFICE, CLM_MIPR_PREPARED_DATE CLM_MIPR_PREPARED_DATE, CLM_MIPR_REF_NUM CLM_MIPR_REF_NUM, CLM_MIPR_TYPE CLM_MIPR_TYPE, CLM_REQ_OFFICE CLM_REQ_OFFICE, PAR_DRAFT_ID PAR_DRAFT_ID, PAR_FLAG PAR_FLAG, CLM_MIPR_ACKNOWLEDGED_FLAG CLM_MIPR_ACKNOWLEDGED_FLAG, CLM_ASSIST_CONTACT CLM_ASSIST_CONTACT, CLM_REQ_CONTACT CLM_REQ_CONTACT from "PO"."PO_REQUISITION_HEADERS_ALL"

View Text - HTML Formatted

SELECT REQUISITION_HEADER_ID REQUISITION_HEADER_ID
, PREPARER_ID PREPARER_ID
, 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
, DESCRIPTION DESCRIPTION
, AUTHORIZATION_STATUS AUTHORIZATION_STATUS
, NOTE_TO_AUTHORIZER NOTE_TO_AUTHORIZER
, TYPE_LOOKUP_CODE TYPE_LOOKUP_CODE
, TRANSFERRED_TO_OE_FLAG TRANSFERRED_TO_OE_FLAG
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ON_LINE_FLAG ON_LINE_FLAG
, PRELIMINARY_RESEARCH_FLAG PRELIMINARY_RESEARCH_FLAG
, RESEARCH_COMPLETE_FLAG RESEARCH_COMPLETE_FLAG
, PREPARER_FINISHED_FLAG PREPARER_FINISHED_FLAG
, PREPARER_FINISHED_DATE PREPARER_FINISHED_DATE
, AGENT_RETURN_FLAG AGENT_RETURN_FLAG
, AGENT_RETURN_NOTE AGENT_RETURN_NOTE
, CANCEL_FLAG CANCEL_FLAG
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, 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
, INTERFACE_SOURCE_CODE INTERFACE_SOURCE_CODE
, INTERFACE_SOURCE_LINE_ID INTERFACE_SOURCE_LINE_ID
, CLOSED_CODE CLOSED_CODE
, ORG_ID ORG_ID
, WF_ITEM_TYPE WF_ITEM_TYPE
, WF_ITEM_KEY WF_ITEM_KEY
, EMERGENCY_PO_NUM EMERGENCY_PO_NUM
, PCARD_ID PCARD_ID
, APPS_SOURCE_CODE APPS_SOURCE_CODE
, CBC_ACCOUNTING_DATE CBC_ACCOUNTING_DATE
, CHANGE_PENDING_FLAG CHANGE_PENDING_FLAG
, ACTIVE_SHOPPING_CART_FLAG ACTIVE_SHOPPING_CART_FLAG
, CONTRACTOR_STATUS CONTRACTOR_STATUS
, CONTRACTOR_REQUISITION_FLAG CONTRACTOR_REQUISITION_FLAG
, SUPPLIER_NOTIFIED_FLAG SUPPLIER_NOTIFIED_FLAG
, EMERGENCY_PO_ORG_ID EMERGENCY_PO_ORG_ID
, APPROVED_DATE APPROVED_DATE
, TAX_ATTRIBUTE_UPDATE_CODE TAX_ATTRIBUTE_UPDATE_CODE
, FIRST_APPROVER_ID FIRST_APPROVER_ID
, FIRST_POSITION_ID FIRST_POSITION_ID
, FEDERAL_FLAG FEDERAL_FLAG
, CONFORMED_HEADER_ID CONFORMED_HEADER_ID
, REVISION_NUM REVISION_NUM
, AMENDMENT_TYPE AMENDMENT_TYPE
, AMENDMENT_STATUS AMENDMENT_STATUS
, AMENDMENT_REASON AMENDMENT_REASON
, UDA_TEMPLATE_ID UDA_TEMPLATE_ID
, UDA_TEMPLATE_DATE UDA_TEMPLATE_DATE
, CLM_ISSUING_OFFICE CLM_ISSUING_OFFICE
, CLM_COTR_OFFICE CLM_COTR_OFFICE
, CLM_COTR_CONTACT CLM_COTR_CONTACT
, CLM_PRIORITY_CODE CLM_PRIORITY_CODE
, SUGGESTED_AWARD_NO SUGGESTED_AWARD_NO
, CLM_ASSIST_OFFICE CLM_ASSIST_OFFICE
, CLM_MIPR_PREPARED_DATE CLM_MIPR_PREPARED_DATE
, CLM_MIPR_REF_NUM CLM_MIPR_REF_NUM
, CLM_MIPR_TYPE CLM_MIPR_TYPE
, CLM_REQ_OFFICE CLM_REQ_OFFICE
, PAR_DRAFT_ID PAR_DRAFT_ID
, PAR_FLAG PAR_FLAG
, CLM_MIPR_ACKNOWLEDGED_FLAG CLM_MIPR_ACKNOWLEDGED_FLAG
, CLM_ASSIST_CONTACT CLM_ASSIST_CONTACT
, CLM_REQ_CONTACT CLM_REQ_CONTACT
FROM "PO"."PO_REQUISITION_HEADERS_ALL"