POI_M_H_BUILD_APPLY_V

Details

• Schema: FUSION

• Object owner: POI

• Object type: VIEW

Columns

Name

SOURCE_TABLE DATASOURCE_NUM_ID TXN_ID SPEND_TXN_TYPE TXN_NUM LINE_NUM TXN_DATE TXN_DESC LINE_DESC ITEM_CODE ITEM_DESCRIPTION SUPPLIER_NAME SUPPLIER_SITE OPERATING_UNIT UOM LINE_QUANTITY CURRENCY UNIT_PRICE LINE_AMOUNT COST_CENTER EBS_CATEGORY_CODE UNSPSC_CATEGORY_CODE CUSTOM_CATEGORY_CODE1 CUSTOM_CATEGORY_CODE2 CUSTOM_CATEGORY_CODE3 EBS_AUTO_CODE UNSPSC_AUTO_CODE CUSTOM_AUTO_CODE1 CUSTOM_AUTO_CODE2 CUSTOM_AUTO_CODE3 W_UPDATE_DT FACT_INTEGRATION_ID FACT_TABLE ITEM_TEXT AMOUNT BU_ID

Query

SQL_Statement

select source_table,datasource_num_id,txn_id,spend_txn_type,txn_num,line_num,txn_date,txn_desc,line_desc,item_code,item_description,supplier_name,supplier_site,operating_unit,uom,line_quantity,currency,unit_price,line_amount,cost_center,ebs_category_code,unspsc_category_code,custom_category_code1,custom_category_code2,custom_category_code3,ebs_auto_code,unspsc_auto_code,custom_auto_code1,custom_auto_code2,custom_auto_code3,w_update_dt,FACT_INTEGRATION_ID,FACT_TABLE, txn_desc||' '||line_desc||' '||ITEM_DESCRIPTION||' '||item_code||' '||supplier_name||' '||supplier_site||' '||operating_unit||' '||uom||' '||currency item_text, a.line_amount AMOUNT, a.bu_id FROM POI_ALL_SPEND_DATA_V a