CMR_B_ALL_PERIOD_VALERR_TXNS_V

Details

• Schema: FUSION

• Object owner: CST

• 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 cps.bu_id, cps.period_name, cps.period_set_name, cps.ledger_id, cps.period_type, cps.period_num, cps.period_year, cps.start_date, cps.end_date, cps.le_time_offset, cps.server_start_date, cps.server_end_date, capct.transaction_id, capct.source_table, capct.bill_to_business_unit_id, capct.inventory_org_id, capct.item_organization_id, capct.transaction_type, capct.document_type_code, capct.transaction_number, capct.transaction_date, capct.transaction_line_number, capct.destination_type_code, capct.distribution_type, capct.inventory_item_id, capct.transaction_qty, capct.transaction_uom_code, capct.transaction_amt, capct.currency_code, capct.error_code FROM cmr_period_statuses_v cps, cmr_all_period_close_txns_v capct WHERE capct.bill_to_business_unit_id = cps.bu_id AND TRUNC(capct.transaction_date + capct.convert_to_letz*le_time_offset) <= cps.end_date