CST_UNINTF_TXNS_PIVOT_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name
COST_ORG_ID COST_BOOK_ID PERIOD_NAME REQUEST_ID PENDING_INV_INTF_COUNT PENDING_MFG_INTF_COUNT PENDING_REV_INTF_COUNT PENDING_AP_INTF_COUNT

Query

SQL_Statement

SELECT Cost_Org_Id, Cost_Book_Id, Period_Name, request_id, sum(decode(source, 'ORA_CST_INV', count, NULL)) pending_inv_intf_count, sum(decode(source, 'ORA_CST_MFG', count, NULL)) pending_mfg_intf_count, sum(decode(source, 'ORA_CST_AR', count, NULL)) pending_rev_intf_count, sum(decode(source, 'ORA_CST_AP', count, NULL)) pending_ap_intf_count FROM cst_uninterfaced_txns group by Cost_Org_Id, Cost_Book_Id, Period_Name, request_id