AP_PO_HEADERS_EXTRACT_V

Details

• Schema: FUSION

• Object owner: AP

• Object type: VIEW

Columns

Name

PO_HEADER_ID POH_TYPE_LOOKUP_CODE PO_NUMBER POH_SEGMENT2 POH_SEGMENT3 POH_SEGMENT4 POH_SEGMENT5 POH_CURRENCY_CODE POH_ATTRIBUTE_CATEGORY POH_ATTRIBUTE1 POH_ATTRIBUTE2 POH_ATTRIBUTE3 POH_ATTRIBUTE4 POH_ATTRIBUTE5 POH_ATTRIBUTE6 POH_ATTRIBUTE7 POH_ATTRIBUTE8 POH_ATTRIBUTE9 POH_ATTRIBUTE10 POH_ATTRIBUTE11 POH_ATTRIBUTE12 POH_ATTRIBUTE13 POH_ATTRIBUTE14 POH_ATTRIBUTE15 POH_GLOBAL_ATTRIBUTE_CATEGORY POH_GLOBAL_ATTRIBUTE1 POH_GLOBAL_ATTRIBUTE2 POH_GLOBAL_ATTRIBUTE3 POH_GLOBAL_ATTRIBUTE4 POH_GLOBAL_ATTRIBUTE5 POH_GLOBAL_ATTRIBUTE6 POH_GLOBAL_ATTRIBUTE7 POH_GLOBAL_ATTRIBUTE8 POH_GLOBAL_ATTRIBUTE9 POH_GLOBAL_ATTRIBUTE10 POH_GLOBAL_ATTRIBUTE11 POH_GLOBAL_ATTRIBUTE12 POH_GLOBAL_ATTRIBUTE13 POH_GLOBAL_ATTRIBUTE14 POH_GLOBAL_ATTRIBUTE15 POH_GLOBAL_ATTRIBUTE16 POH_GLOBAL_ATTRIBUTE17 POH_GLOBAL_ATTRIBUTE18 POH_GLOBAL_ATTRIBUTE19 POH_GLOBAL_ATTRIBUTE20 POH_REFERENCE_NUM POH_RATE POH_RATE_DATE POH_RATE_TYPE BUDGET_CONTROL_ENABLED_FLAG

Query

SQL_Statement

SELECT POH.PO_Header_Id PO_HEADER_ID ,POH.TYPE_LOOKUP_CODE POH_TYPE_LOOKUP_CODE ,POH.SEGMENT1 PO_NUMBER ,POH.SEGMENT2 POH_SEGMENT2 ,POH.SEGMENT3 POH_SEGMENT3 ,POH.SEGMENT4 POH_SEGMENT4 ,POH.SEGMENT5 POH_SEGMENT5 ,POH.CURRENCY_CODE POH_CURRENCY_CODE ,POH.ATTRIBUTE_CATEGORY POH_ATTRIBUTE_CATEGORY ,POH.ATTRIBUTE1 POH_ATTRIBUTE1 ,POH.ATTRIBUTE2 POH_ATTRIBUTE2 ,POH.ATTRIBUTE3 POH_ATTRIBUTE3 ,POH.ATTRIBUTE4 POH_ATTRIBUTE4 ,POH.ATTRIBUTE5 POH_ATTRIBUTE5 ,POH.ATTRIBUTE6 POH_ATTRIBUTE6 ,POH.ATTRIBUTE7 POH_ATTRIBUTE7 ,POH.ATTRIBUTE8 POH_ATTRIBUTE8 ,POH.ATTRIBUTE9 POH_ATTRIBUTE9 ,POH.ATTRIBUTE10 POH_ATTRIBUTE10 ,POH.ATTRIBUTE11 POH_ATTRIBUTE11 ,POH.ATTRIBUTE12 POH_ATTRIBUTE12 ,POH.ATTRIBUTE13 POH_ATTRIBUTE13 ,POH.ATTRIBUTE14 POH_ATTRIBUTE14 ,POH.ATTRIBUTE15 POH_ATTRIBUTE15 ,POH.GLOBAL_ATTRIBUTE_CATEGORY POH_GLOBAL_ATTRIBUTE_CATEGORY ,POH.GLOBAL_ATTRIBUTE1 POH_GLOBAL_ATTRIBUTE1 ,POH.GLOBAL_ATTRIBUTE2 POH_GLOBAL_ATTRIBUTE2 ,POH.GLOBAL_ATTRIBUTE3 POH_GLOBAL_ATTRIBUTE3 ,POH.GLOBAL_ATTRIBUTE4 POH_GLOBAL_ATTRIBUTE4 ,POH.GLOBAL_ATTRIBUTE5 POH_GLOBAL_ATTRIBUTE5 ,POH.GLOBAL_ATTRIBUTE6 POH_GLOBAL_ATTRIBUTE6 ,POH.GLOBAL_ATTRIBUTE7 POH_GLOBAL_ATTRIBUTE7 ,POH.GLOBAL_ATTRIBUTE8 POH_GLOBAL_ATTRIBUTE8 ,POH.GLOBAL_ATTRIBUTE9 POH_GLOBAL_ATTRIBUTE9 ,POH.GLOBAL_ATTRIBUTE10 POH_GLOBAL_ATTRIBUTE10 ,POH.GLOBAL_ATTRIBUTE11 POH_GLOBAL_ATTRIBUTE11 ,POH.GLOBAL_ATTRIBUTE12 POH_GLOBAL_ATTRIBUTE12 ,POH.GLOBAL_ATTRIBUTE13 POH_GLOBAL_ATTRIBUTE13 ,POH.GLOBAL_ATTRIBUTE14 POH_GLOBAL_ATTRIBUTE14 ,POH.GLOBAL_ATTRIBUTE15 POH_GLOBAL_ATTRIBUTE15 ,POH.GLOBAL_ATTRIBUTE16 POH_GLOBAL_ATTRIBUTE16 ,POH.GLOBAL_ATTRIBUTE17 POH_GLOBAL_ATTRIBUTE17 ,POH.GLOBAL_ATTRIBUTE18 POH_GLOBAL_ATTRIBUTE18 ,POH.GLOBAL_ATTRIBUTE19 POH_GLOBAL_ATTRIBUTE19 ,POH.GLOBAL_ATTRIBUTE20 POH_GLOBAL_ATTRIBUTE20 ,POH.REFERENCE_NUM POH_REFERENCE_NUM ,POH.RATE POH_RATE ,nvl(POH.RATE_DATE,POH.CREATION_DATE) POH_RATE_DATE ,POH.RATE_TYPE POH_RATE_TYPE ,POH.BUDGET_CONTROL_ENABLED_FLAG FROM PO_HEADERS_ALL POH