1. Tables and Views for Financials
  2. VRM_XLA_SALESREP_V

VRM_XLA_SALESREP_V

Details

  • Schema: FUSION

  • Object owner: VRM

  • Object type: VIEW

Columns

Name

SALESREP_REV_CCID

REV_SPLIT_SALESREP_NAME

SALESREP_NUMBER

EVENT_ID

LINE_NUMBER

LEDGER_ID

Query

SQL_Statement

SELECT /*+ INDEX(l VRM_XLA_IFRS15_EXTRACT_GT_N1) */

ref.REV_CCID SALESREP_REV_CCID,

DECODE(slnf.RESOURCE_ID, -1, 'No Sales Credit',

HZP.PARTY_NAME) REV_SPLIT_SALESREP_NAME,

slnf.SALESREP_NUMBER SALESREP_NUMBER,

/*splits.REVENUE_ACCOUNT_CCID REVENUE_SPLIT_REV_CCID, moved to REVENUE_LINES*/

l.EVENT_ID EVENT_ID,

l.LINE_NUMBER LINE_NUMBER,

l.LEDGER_ID LEDGER_ID

FROM VRM_XLA_IFRS15_EXTRACT_GT l,

VRM_PERF_OBLIGATION_LIN_SPLITS splits ,

JTF_RS_SALESREPS slnf ,

HZ_PARTIES hzp,

AR_REF_ACCOUNTS_ALL ref

WHERE l.LEVEL_CODE = 'L'

AND splits.PERF_OBLIGATION_LINE_SPLIT_ID = l.PERF_OBLIGATION_LINE_SPLIT_ID

AND slnf.RESOURCE_SALESREP_ID = splits.SALESREP_ID

AND slnf.SET_ID IN (0, FND_SetID_Utility.getSetID( 'HZ_SALES_PERSON', 'BU', l.bu_id))

AND HZP.PARTY_ID (+) = slnf.RESOURCE_ID

AND REF.SOURCE_REF_ACCOUNT_ID(+) = L.PERF_OBLIG_LINE_SALESREP_ID

AND REF.SOURCE_REF_TABLE (+) = 'RA_SALESREPS'

AND ref.BU_ID (+) = l.BU_ID