RA_SALESREPS

Details

• Schema: FUSION

• Object owner: AR

• Object type: VIEW

Columns

Name

RESOURCE_SALESREP_ID PARTY_ID LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN SALES_CREDIT_TYPE_ID NAME SALESREP_NUMBER STATUS START_DATE_ACTIVE END_DATE_ACTIVE ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 SET_ID WH_UPDATE_DATE SALES_TAX_GEOCODE SALES_TAX_INSIDE_CITY_LIMITS

Query

SQL_Statement

SELECT JRS.RESOURCE_SALESREP_ID, HZP.PARTY_ID, JRS.LAST_UPDATE_DATE, JRS.LAST_UPDATED_BY, JRS.CREATION_DATE, JRS.CREATED_BY, JRS.LAST_UPDATE_LOGIN, JRS.SALES_CREDIT_TYPE_ID, HZP.PARTY_NAME NAME , JRS.SALESREP_NUMBER, JRS.STATUS, JRS.START_DATE_ACTIVE, JRS.END_DATE_ACTIVE, JRS.ATTRIBUTE_CATEGORY, JRS.ATTRIBUTE1, JRS.ATTRIBUTE2, JRS.ATTRIBUTE3, JRS.ATTRIBUTE4, JRS.ATTRIBUTE5, JRS.ATTRIBUTE6, JRS.ATTRIBUTE7, JRS.ATTRIBUTE8, JRS.ATTRIBUTE9, JRS.ATTRIBUTE10, JRS.ATTRIBUTE11, JRS.ATTRIBUTE12, JRS.ATTRIBUTE13, JRS.ATTRIBUTE14, JRS.ATTRIBUTE15, JRS.SET_ID, JRS.WH_UPDATE_DATE, JRS.SALES_TAX_GEOCODE, JRS.SALES_TAX_INSIDE_CITY_LIMITS FROM JTF_RS_SALESREPS JRS, HZ_PARTIES HZP WHERE JRS.RESOURCE_ID = HZP.PARTY_ID UNION ALL SELECT -1, /* resource_salesrep_id */ -1, /* party_id */ sysdate, /* last_update_date */ '0', /* last_updated_by */ sysdate, /* creation_date */ '0', /* created_by */ '0', /* last_update_login */ 1, /* sales_credit_type_id */ lk.meaning NAME , /* name */ '-3', /* salesrep_number */ 'A', /* status */ To_Date('01-01-1900', 'DD-MM-YYYY'), /* start_date_active */ NULL, /* end_date_active */ NULL, /* attribute_category */ NULL, /* attribute1 */ NULL, /* attribute2 */ NULL, /* attribute3 */ NULL, /* attribute4 */ NULL, /* attribute5 */ NULL, /* attribute6 */ NULL, /* attribute7 */ NULL, /* attribute8 */ NULL, /* attribute9 */ NULL, /* attribute10 */ NULL, /* attribute11 */ NULL, /* attribute12 */ NULL, /* attribute13 */ NULL, /* attribute14 */ NULL, /* attribute15 */ 0, /* set_id */ NULL, /* wh_update_date */ NULL, /* sales_tax_geocode */ NULL /* sales_tax_inside_city_limits */ FROM ar_lookups lk WHERE lk.lookup_type = 'AR_SALES_CREDIT' AND lk.lookup_code = 'NO_SALES_CREDIT'