VIEW: APPS.PO_REQ_HEADERS_TRX_V

Source

View Text - Preformatted

SELECT PRH.REQUISITION_HEADER_ID, PRH.PREPARER_ID, PRH.LAST_UPDATE_DATE, PRH.LAST_UPDATED_BY, PRH.SEGMENT1, PRH.SUMMARY_FLAG, PRH.ENABLED_FLAG, PRH.SEGMENT2, PRH.SEGMENT3, PRH.SEGMENT4, PRH.SEGMENT5, PRH.START_DATE_ACTIVE, PRH.END_DATE_ACTIVE, PRH.LAST_UPDATE_LOGIN, PRH.CREATION_DATE, PRH.CREATED_BY, PRH.DESCRIPTION, PRH.AUTHORIZATION_STATUS, PRH.NOTE_TO_AUTHORIZER, PRH.TYPE_LOOKUP_CODE, PRH.TRANSFERRED_TO_OE_FLAG, PRH.ATTRIBUTE_CATEGORY, PRH.ATTRIBUTE1, PRH.ATTRIBUTE2, PRH.ATTRIBUTE3, PRH.ATTRIBUTE4, PRH.ATTRIBUTE5, PRH.ON_LINE_FLAG, PRH.PRELIMINARY_RESEARCH_FLAG, PRH.RESEARCH_COMPLETE_FLAG, PRH.PREPARER_FINISHED_FLAG, PRH.PREPARER_FINISHED_DATE, PRH.AGENT_RETURN_FLAG, PRH.AGENT_RETURN_NOTE, PRH.CANCEL_FLAG, PRH.ATTRIBUTE6, PRH.ATTRIBUTE7, PRH.ATTRIBUTE8, PRH.ATTRIBUTE9, PRH.ATTRIBUTE10, PRH.ATTRIBUTE11, PRH.ATTRIBUTE12, PRH.ATTRIBUTE13, PRH.ATTRIBUTE14, PRH.ATTRIBUTE15, PRH.USSGL_TRANSACTION_CODE, PRH.GOVERNMENT_CONTEXT, PRH.REQUEST_ID, PRH.PROGRAM_APPLICATION_ID, PRH.PROGRAM_ID, PRH.PROGRAM_UPDATE_DATE, PRH.INTERFACE_SOURCE_CODE, PRH.INTERFACE_SOURCE_LINE_ID, PRH.CLOSED_CODE, PRH.ORG_ID, PRH.WF_ITEM_TYPE, PRH.WF_ITEM_KEY, PRH.EMERGENCY_PO_NUM, PRH.PCARD_ID, PRH.APPS_SOURCE_CODE, PRH.CBC_ACCOUNTING_DATE, PRH.CHANGE_PENDING_FLAG, PRH.ACTIVE_SHOPPING_CART_FLAG, PRH.CONTRACTOR_STATUS, PRH.CONTRACTOR_REQUISITION_FLAG, PRH.SUPPLIER_NOTIFIED_FLAG, PRH.EMERGENCY_PO_ORG_ID, PRH.APPROVED_DATE, PRH.TAX_ATTRIBUTE_UPDATE_CODE, PRH.FIRST_APPROVER_ID, PRH.FIRST_POSITION_ID, PRH.FEDERAL_FLAG, PRH.CONFORMED_HEADER_ID, PRH.REVISION_NUM, PRH.AMENDMENT_TYPE, PRH.AMENDMENT_STATUS, PRH.AMENDMENT_REASON, PRH.UDA_TEMPLATE_ID, PRH.UDA_TEMPLATE_DATE, PRH.CLM_ISSUING_OFFICE, PRH.CLM_COTR_OFFICE, PRH.CLM_COTR_CONTACT, PRH.CLM_PRIORITY_CODE, PRH.SUGGESTED_AWARD_NO FROM PO_REQUISITION_HEADERS PRH WHERE PRH.CONFORMED_HEADER_ID IS NULL

View Text - HTML Formatted

SELECT PRH.REQUISITION_HEADER_ID
, PRH.PREPARER_ID
, PRH.LAST_UPDATE_DATE
, PRH.LAST_UPDATED_BY
, PRH.SEGMENT1
, PRH.SUMMARY_FLAG
, PRH.ENABLED_FLAG
, PRH.SEGMENT2
, PRH.SEGMENT3
, PRH.SEGMENT4
, PRH.SEGMENT5
, PRH.START_DATE_ACTIVE
, PRH.END_DATE_ACTIVE
, PRH.LAST_UPDATE_LOGIN
, PRH.CREATION_DATE
, PRH.CREATED_BY
, PRH.DESCRIPTION
, PRH.AUTHORIZATION_STATUS
, PRH.NOTE_TO_AUTHORIZER
, PRH.TYPE_LOOKUP_CODE
, PRH.TRANSFERRED_TO_OE_FLAG
, PRH.ATTRIBUTE_CATEGORY
, PRH.ATTRIBUTE1
, PRH.ATTRIBUTE2
, PRH.ATTRIBUTE3
, PRH.ATTRIBUTE4
, PRH.ATTRIBUTE5
, PRH.ON_LINE_FLAG
, PRH.PRELIMINARY_RESEARCH_FLAG
, PRH.RESEARCH_COMPLETE_FLAG
, PRH.PREPARER_FINISHED_FLAG
, PRH.PREPARER_FINISHED_DATE
, PRH.AGENT_RETURN_FLAG
, PRH.AGENT_RETURN_NOTE
, PRH.CANCEL_FLAG
, PRH.ATTRIBUTE6
, PRH.ATTRIBUTE7
, PRH.ATTRIBUTE8
, PRH.ATTRIBUTE9
, PRH.ATTRIBUTE10
, PRH.ATTRIBUTE11
, PRH.ATTRIBUTE12
, PRH.ATTRIBUTE13
, PRH.ATTRIBUTE14
, PRH.ATTRIBUTE15
, PRH.USSGL_TRANSACTION_CODE
, PRH.GOVERNMENT_CONTEXT
, PRH.REQUEST_ID
, PRH.PROGRAM_APPLICATION_ID
, PRH.PROGRAM_ID
, PRH.PROGRAM_UPDATE_DATE
, PRH.INTERFACE_SOURCE_CODE
, PRH.INTERFACE_SOURCE_LINE_ID
, PRH.CLOSED_CODE
, PRH.ORG_ID
, PRH.WF_ITEM_TYPE
, PRH.WF_ITEM_KEY
, PRH.EMERGENCY_PO_NUM
, PRH.PCARD_ID
, PRH.APPS_SOURCE_CODE
, PRH.CBC_ACCOUNTING_DATE
, PRH.CHANGE_PENDING_FLAG
, PRH.ACTIVE_SHOPPING_CART_FLAG
, PRH.CONTRACTOR_STATUS
, PRH.CONTRACTOR_REQUISITION_FLAG
, PRH.SUPPLIER_NOTIFIED_FLAG
, PRH.EMERGENCY_PO_ORG_ID
, PRH.APPROVED_DATE
, PRH.TAX_ATTRIBUTE_UPDATE_CODE
, PRH.FIRST_APPROVER_ID
, PRH.FIRST_POSITION_ID
, PRH.FEDERAL_FLAG
, PRH.CONFORMED_HEADER_ID
, PRH.REVISION_NUM
, PRH.AMENDMENT_TYPE
, PRH.AMENDMENT_STATUS
, PRH.AMENDMENT_REASON
, PRH.UDA_TEMPLATE_ID
, PRH.UDA_TEMPLATE_DATE
, PRH.CLM_ISSUING_OFFICE
, PRH.CLM_COTR_OFFICE
, PRH.CLM_COTR_CONTACT
, PRH.CLM_PRIORITY_CODE
, PRH.SUGGESTED_AWARD_NO
FROM PO_REQUISITION_HEADERS PRH
WHERE PRH.CONFORMED_HEADER_ID IS NULL