1. Tables and Views for SCM
  2. CMR_PERIOD_CLOSE_ACTIONS_V

CMR_PERIOD_CLOSE_ACTIONS_V

Details

  • Schema: FUSION

  • Object owner: CMR

  • Object type: VIEW

Columns

Name

BU_ID

PERIOD_SET_NAME

LEDGER_ID

LEGAL_ENTITY_ID

PERIOD_TYPE

PERIOD_NAME

PERIOD_NUM

PERIOD_YEAR

START_DATE

END_DATE

LE_TIME_OFFSET

SERVER_START_DATE

SERVER_END_DATE

PENDING_RECEIPT_COUNT

PENDING_TRA_COUNT

PENDING_INVOICE_VAR_COUNT

PENDING_ACCR_CLR_COUNT

PENDING_PERIOD_ACCR_COUNT

PENDING_RPA_COUNT

PENDING_RECEIPT_INTF_COUNT

PENDING_INVOICE_INTF_COUNT

PENDING_TRA_INTF_COUNT

UNIMPORTED_RECEIPT_COUNT

UNIMPORTED_INVOICE_COUNT

PENDING_DIST_COUNT

Query

SQL_Statement

SELECT business_unit_id bu_id,

period_set_name period_set_name,

ledger_id ledger_id,

legal_entity_id legal_entity_id,

period_type period_type,

period_name period_name,

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,

pending_receipt_count pending_receipt_count,

pending_tra_count pending_tra_count,

pending_invoice_var_count pending_invoice_var_count,

pending_accr_clr_count pending_accr_clr_count,

pending_period_accr_count pending_period_accr_count,

pending_rpa_count pending_rpa_count,

pending_receipt_intf_count pending_receipt_intf_count,

pending_invoice_intf_count pending_invoice_intf_count,

pending_tra_intf_count pending_tra_intf_count,

unimported_receipt_count unimported_receipt_count,

unimported_invoice_count unimported_invoice_count,

pending_dist_count pending_dist_count

FROM cmr_period_close_actions