1. Tables and Views for Financials
  2. VRM_SALESREP_L_V

VRM_SALESREP_L_V

Details

  • Schema: FUSION

  • Object owner: VRM

  • Object type: VIEW

Columns

Name

REP_L_FREIGHT_CCID

REP_L_REC_CCID

REP_L_REV_CCID

REP_L_NAME

REP_L_SALESREP_NUMBER

REP_L_SALES_TAX_GEOCODE

REP_L_SALES_TAX_INSIDE_CITY_LM

REP_L_SALESREP_ID

EVENT_ID

LINE_NUMBER

LEDGER_ID

Query

SQL_Statement

SELECT

/*+ INDEX(l VRM_XLA_LINES_EXTRACT_N1) */

ref.freight_ccid rep_l_freight_ccid ,

ref.rec_ccid rep_l_rec_ccid ,

ref.rev_ccid rep_l_rev_ccid ,

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

slnf.salesrep_number rep_l_salesrep_number ,

slnf.sales_tax_geocode rep_l_sales_tax_geocode ,

slnf.sales_tax_inside_city_limits rep_l_sales_tax_inside_city_lm ,

slnf.RESOURCE_SALESREP_ID REP_L_SALESREP_ID ,

l.event_id event_id ,

l.line_number line_number ,

l.ledger_id ledger_id

FROM VRM_REV_DOC_LINE_SPLITS_ALL rdspt ,

jtf_rs_salesreps slnf ,

HZ_PARTIES hzp,

ar_ref_accounts_All ref,

vrm_xla_lines_extract_gt l

WHERE rdspt.REVENUE_LINE_SPLIT_ID = l.REVENUE_LINE_SPLIT_ID

AND l.level_flag = 'L'

AND rdspt.org_id = l.org_id

AND slnf.set_id = FND_SetID_Utility.getSetID( 'HZ_SALES_PERSON', 'BU', l.org_id)

AND ref.source_ref_table(+) = 'RA_SALESREPS'

AND ref.bu_id(+) = l.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.salesrep_number ,

slnf.sales_tax_geocode ,

slnf.sales_tax_inside_city_limits ,

slnf.RESOURCE_SALESREP_ID,

l.event_id ,

L.LINE_NUMBER ,

l.ledger_id