AR_CM_SALESREP_S_V
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: VIEW
Columns
Name |
---|
CM_REP_H_FREIGHT_CCID CM_REP_H_REC_CCID CM_REP_H_REV_CCID CM_REP_H_NAME CM_REP_H_SALESREP_ID CM_REP_H_SALESREP_NUMBER CM_REP_H_SALES_TAX_GEOCODE CM_REP_H_SALES_TAX_INS_CITY_LM EVENT_ID LINE_NUMBER LEDGER_ID LANGUAGE |
Query
SQL_Statement |
---|
SELECT ref.freight_ccid cm_rep_h_freight_ccid , ref.rec_ccid cm_rep_h_rec_ccid , ref.rev_ccid cm_rep_h_rev_ccid , decode(shdrt.RESOURCE_ID, -1, 'No Sales Credit', HZP.PARTY_NAME) cm_rep_h_name, shdrt.resource_salesrep_id cm_rep_h_salesrep_id , shdrt.salesrep_number cm_rep_h_salesrep_number , shdrt.sales_tax_geocode cm_rep_h_sales_tax_geocode , shdrt.sales_tax_inside_city_limits cm_rep_h_sales_tax_ins_city_lm , he.event_id event_id , he.line_number line_number , he.ledger_id ledger_id , he.language language FROM jtf_rs_salesreps shdrt , HZ_PARTIES hzp, ar_ref_accounts_All ref, ar_xla_lines_extract he WHERE shdrt.resource_salesrep_id = he.resource_salesrep_id AND he.level_flag = 'H' AND he.event_class_code = 'CREDIT_MEMO' AND shdrt.set_id = FND_SetID_Utility.getSetID( 'HZ_SALES_PERSON', 'BU', he.org_id) AND ref.source_ref_table(+) = 'RA_SALESREPS' AND ref.source_ref_account_id(+) = he.resource_salesrep_id ANd ref.bu_id(+) = he.org_id AND shdrt.RESOURCE_ID = HZP.PARTY_ID (+) |