CMR_ALL_PERIOD_VALERR_TXNS_V

Details

• Schema: FUSION

• Object owner: CMR

• Object type: VIEW

Columns

Name

BU_ID PERIOD_NAME PERIOD_SET_NAME LEDGER_ID PERIOD_TYPE PERIOD_NUM PERIOD_YEAR START_DATE END_DATE LE_TIME_OFFSET SERVER_START_DATE SERVER_END_DATE TRANSACTION_ID SOURCE_TABLE BILL_TO_BUSINESS_UNIT_ID INVENTORY_ORG_ID ITEM_ORGANIZATION_ID TRANSACTION_TYPE DOCUMENT_TYPE_CODE TRANSACTION_NUMBER TRANSACTION_DATE TRANSACTION_LINE_NUMBER DESTINATION_TYPE_CODE DISTRIBUTION_TYPE INVENTORY_ITEM_ID TRANSACTION_QTY TRANSACTION_UOM_CODE TRANSACTION_AMT CURRENCY_CODE ERROR_CODE

Query

SQL_Statement

SELECT bu_id bu_id, period_name period_name, period_set_name period_set_name, ledger_id ledger_id, period_type period_type, period_num period_num, period_year period_year, start_date start_date, end_date end_date, le_time_offset le_time_offset, server_start_date server_start_date, server_end_date server_end_date, transaction_id transaction_id, source_table source_table, bill_to_business_unit_id bill_to_business_unit_id, inventory_org_id inventory_org_id, item_organization_id item_organization_id, transaction_type transaction_type, document_type_code document_type_code, transaction_number transaction_number, transaction_date transaction_date, transaction_line_number transaction_line_number, destination_type_code destination_type_code, distribution_type distribution_type, inventory_item_id inventory_item_id, transaction_qty transaction_qty, transaction_uom_code transaction_uom_code, transaction_amt transaction_amt, currency_code currency_code, error_code error_code FROM cmr_all_period_valerr_txns