1. Tables and Views for Financials
  2. AR_CM_SALESREP_L_V

AR_CM_SALESREP_L_V

Details

  • Schema: FUSION

  • Object owner: AR

  • Object type: VIEW

Columns

Name

CM_REP_L_FREIGHT_CCID

CM_REP_L_REC_CCID

CM_REP_L_REV_CCID

CM_REP_L_NAME

CM_REP_L_SALESREP_ID

CM_REP_L_SALESREP_NUMBER

CM_REP_L_SALES_TAX_GEOCODE

CM_REP_L_SALES_TAX_INS_CITY_LM

EVENT_ID

LINE_NUMBER

LANGUAGE

LEDGER_ID

Query

SQL_Statement

SELECT

/*+INDEX(l ar_xla_lines_extract_n1)*/

ref.freight_ccid cm_rep_l_freight_ccid ,

ref.rec_ccid cm_rep_l_rec_ccid ,

ref.rev_ccid cm_rep_l_rev_ccid ,

decode(slnf.RESOURCE_ID, -1, 'No Sales Credit', HZP.PARTY_NAME) cm_rep_l_name,

slnf.resource_salesrep_id cm_rep_l_salesrep_id ,

slnf.salesrep_number cm_rep_l_salesrep_number ,

slnf.sales_tax_geocode cm_rep_l_sales_tax_geocode ,

slnf.sales_tax_inside_city_limits cm_rep_l_sales_tax_ins_city_lm ,

l.event_id event_id ,

l.line_number line_number ,

l.language language ,

l.ledger_id ledger_id

FROM ra_cust_trx_line_salesreps_all ctlsaf ,

jtf_rs_salesreps slnf ,

ar_ref_accounts_All ref,

hz_parties hzp,

ar_xla_lines_extract l

WHERE slnf.resource_salesrep_id = ctlsaf.resource_salesrep_id

AND ctlsaf.cust_trx_line_salesrep_id = l.cust_trx_line_salesrep_id

AND l.level_flag = 'L'

AND ctlsaf.org_id = l.org_id

AND l.event_type_code IN ('CM_CREATE','CM_UPDATE')

AND ref.source_ref_table(+) = 'RA_SALESREPS'

AND ref.source_ref_account_id(+) = ctlsaf.resource_salesrep_id

AND ref.bu_id(+) = ctlsaf.org_id

AND slnf.RESOURCE_ID = HZP.PARTY_ID (+)

GROUP BY ref.freight_ccid ,

ref.rec_ccid ,

ref.rev_ccid ,

decode(slnf.RESOURCE_ID, -1, 'No Sales Credit', HZP.PARTY_NAME),

slnf.resource_salesrep_id ,

slnf.salesrep_number ,

slnf.sales_tax_geocode ,

slnf.sales_tax_inside_city_limits ,

l.event_id ,

l.line_number ,

l.language ,

l.ledger_id