VIEW: APPS.CN_NOTIFY_LOG_V

Source

View Text - Preformatted

SELECT log.NOTIFY_LOG_ID ,log.NOTIFY_LOG_DATE ,log.DELETE_DATE ,log.EVENT_LOG_ID ,log.NOTIFY_NAME ,log.NOTIFY_ACTION ,log.OBJECT_OWNER_ID ,log.OBJECT_ID ,log.OBJECT_TYPE ,log.OBJECT_NAME ,log.STATUS ,log.PRIORITY ,log.LAST_UPDATE_DATE ,log.LAST_UPDATED_BY ,log.LAST_UPDATE_LOGIN ,log.CREATION_DATE ,log.CREATED_BY ,log.ORG_ID ,log.SALESREP_ID ,log.PERIOD_ID ,log.REVERT_STATE ,log.START_DATE ,log.END_DATE ,log.QUOTA_ID ,log.COMP_GROUP_ID ,log.ACTION ,log.ACTION_LINK_ID ,log.BASE_SALESREP_ID ,log.BASE_COMP_GROUP_ID ,log.PHYSICAL_BATCH_ID ,srp.name salesrep_name ,acc.period_name ,lp1.meaning status_name ,lp2.meaning revert_state_name ,comp1.name comp_group_name ,comp2.name base_comp_group_name ,basesrp.name base_salesrep_name FROM cn_notify_log log, cn_salesreps srp, cn_acc_period_statuses_v acc, cn_lookups lp1, cn_lookups lp2, cn_comp_groups comp1, cn_comp_groups comp2, cn_salesreps basesrp WHERE log.salesrep_id = srp.salesrep_id AND log.period_id = acc.period_id AND lp1.lookup_type = 'CALCULATION_STATUS' AND lp1.lookup_code = log.status AND lp2.lookup_type = 'TRX_STATUS' AND lp2.lookup_code = log.revert_state AND log.comp_group_id = comp1.comp_group_id(+) AND log.base_comp_group_id = comp2.comp_group_id(+) AND log.base_salesrep_id = basesrp.salesrep_id(+)

View Text - HTML Formatted

SELECT LOG.NOTIFY_LOG_ID
, LOG.NOTIFY_LOG_DATE
, LOG.DELETE_DATE
, LOG.EVENT_LOG_ID
, LOG.NOTIFY_NAME
, LOG.NOTIFY_ACTION
, LOG.OBJECT_OWNER_ID
, LOG.OBJECT_ID
, LOG.OBJECT_TYPE
, LOG.OBJECT_NAME
, LOG.STATUS
, LOG.PRIORITY
, LOG.LAST_UPDATE_DATE
, LOG.LAST_UPDATED_BY
, LOG.LAST_UPDATE_LOGIN
, LOG.CREATION_DATE
, LOG.CREATED_BY
, LOG.ORG_ID
, LOG.SALESREP_ID
, LOG.PERIOD_ID
, LOG.REVERT_STATE
, LOG.START_DATE
, LOG.END_DATE
, LOG.QUOTA_ID
, LOG.COMP_GROUP_ID
, LOG.ACTION
, LOG.ACTION_LINK_ID
, LOG.BASE_SALESREP_ID
, LOG.BASE_COMP_GROUP_ID
, LOG.PHYSICAL_BATCH_ID
, SRP.NAME SALESREP_NAME
, ACC.PERIOD_NAME
, LP1.MEANING STATUS_NAME
, LP2.MEANING REVERT_STATE_NAME
, COMP1.NAME COMP_GROUP_NAME
, COMP2.NAME BASE_COMP_GROUP_NAME
, BASESRP.NAME BASE_SALESREP_NAME
FROM CN_NOTIFY_LOG LOG
, CN_SALESREPS SRP
, CN_ACC_PERIOD_STATUSES_V ACC
, CN_LOOKUPS LP1
, CN_LOOKUPS LP2
, CN_COMP_GROUPS COMP1
, CN_COMP_GROUPS COMP2
, CN_SALESREPS BASESRP
WHERE LOG.SALESREP_ID = SRP.SALESREP_ID
AND LOG.PERIOD_ID = ACC.PERIOD_ID
AND LP1.LOOKUP_TYPE = 'CALCULATION_STATUS'
AND LP1.LOOKUP_CODE = LOG.STATUS
AND LP2.LOOKUP_TYPE = 'TRX_STATUS'
AND LP2.LOOKUP_CODE = LOG.REVERT_STATE
AND LOG.COMP_GROUP_ID = COMP1.COMP_GROUP_ID(+)
AND LOG.BASE_COMP_GROUP_ID = COMP2.COMP_GROUP_ID(+)
AND LOG.BASE_SALESREP_ID = BASESRP.SALESREP_ID(+)