VIEW: APPS.AS_SALES_CREDITS_V

Source

View Text - Preformatted

SELECT ASSC.ROWID ROW_ID, ASSC.SALES_CREDIT_ID, ASSC.CREDIT_TYPE_ID, ASOSCTYPES.NAME SALES_CREDIT_TYPE, ASSC.LAST_UPDATE_DATE, ASSC.LAST_UPDATED_BY, ASSC.CREATION_DATE, ASSC.CREATED_BY, ASSC.LAST_UPDATE_LOGIN, ASSC.REQUEST_ID, ASSC.PROGRAM_APPLICATION_ID, ASSC.PROGRAM_ID, ASSC.PROGRAM_UPDATE_DATE, ASSC.LEAD_ID, ASSC.LEAD_LINE_ID, ASSC.SALESFORCE_ID, ASSC.PERSON_ID, ASSC.SALESGROUP_ID, ASSC.PARTNER_CUSTOMER_ID, ASSC.PARTNER_ADDRESS_ID, ASSC.DEFAULTED_FROM_OWNER_FLAG, ASSC.ATTRIBUTE_CATEGORY, ASSC.ATTRIBUTE1, ASSC.ATTRIBUTE2, ASSC.ATTRIBUTE3, ASSC.ATTRIBUTE4, ASSC.ATTRIBUTE5, ASSC.ATTRIBUTE6, ASSC.ATTRIBUTE7, ASSC.ATTRIBUTE8, ASSC.ATTRIBUTE9, ASSC.ATTRIBUTE10, ASSC.ATTRIBUTE11, ASSC.ATTRIBUTE12, ASSC.ATTRIBUTE13, ASSC.ATTRIBUTE14, ASSC.ATTRIBUTE15, ASSC.CREDIT_PERCENT, ASSC.CREDIT_AMOUNT, ASSC.OPP_WORST_FORECAST_AMOUNT, ASSC.OPP_FORECAST_AMOUNT, ASSC.OPP_BEST_FORECAST_AMOUNT, RS.SOURCE_FIRST_NAME FIRST_NAME, RS.SOURCE_LAST_NAME LAST_NAME, RS.SOURCE_NAME FULL_NAME, NULL SUFFIX, JTFRSG.GROUP_NAME, NULL CUSTOMER_NAME, NULL COUNTRY, NULL ADDRESS1, NULL ADDRESS2, NULL ADDRESS3, NULL ADDRESS4, NULL CITY, NULL POSTAL_CODE, NULL STATE, NULL PROVINCE, NULL COUNTY FROM AS_SALES_CREDITS ASSC, JTF_RS_RESOURCE_EXTNS RS, JTF_RS_GROUPS_TL JTFRSG, OE_SALES_CREDIT_TYPES ASOSCTYPES WHERE ASSC.SALESGROUP_ID = JTFRSG.GROUP_ID(+) AND JTFRSG.LANGUAGE (+) = USERENV('LANG') AND ASSC.CREDIT_TYPE_ID = ASOSCTYPES.SALES_CREDIT_TYPE_ID AND ASSC.SALESFORCE_ID = RS.RESOURCE_ID AND RS.CATEGORY = 'EMPLOYEE' UNION ALL SELECT ASSC.ROWID ROW_ID, ASSC.SALES_CREDIT_ID, ASSC.CREDIT_TYPE_ID, ASOSCTYPES.NAME SALES_CREDIT_TYPE, ASSC.LAST_UPDATE_DATE, ASSC.LAST_UPDATED_BY, ASSC.CREATION_DATE, ASSC.CREATED_BY, ASSC.LAST_UPDATE_LOGIN, ASSC.REQUEST_ID, ASSC.PROGRAM_APPLICATION_ID, ASSC.PROGRAM_ID, ASSC.PROGRAM_UPDATE_DATE, ASSC.LEAD_ID, ASSC.LEAD_LINE_ID, ASSC.SALESFORCE_ID, ASSC.PERSON_ID, ASSC.SALESGROUP_ID, ASSC.PARTNER_CUSTOMER_ID, ASSC.PARTNER_ADDRESS_ID, ASSC.DEFAULTED_FROM_OWNER_FLAG, ASSC.ATTRIBUTE_CATEGORY, ASSC.ATTRIBUTE1, ASSC.ATTRIBUTE2, ASSC.ATTRIBUTE3, ASSC.ATTRIBUTE4, ASSC.ATTRIBUTE5, ASSC.ATTRIBUTE6, ASSC.ATTRIBUTE7, ASSC.ATTRIBUTE8, ASSC.ATTRIBUTE9, ASSC.ATTRIBUTE10, ASSC.ATTRIBUTE11, ASSC.ATTRIBUTE12, ASSC.ATTRIBUTE13, ASSC.ATTRIBUTE14, ASSC.ATTRIBUTE15, ASSC.CREDIT_PERCENT, ASSC.CREDIT_AMOUNT, ASSC.OPP_WORST_FORECAST_AMOUNT, ASSC.OPP_FORECAST_AMOUNT, ASSC.OPP_BEST_FORECAST_AMOUNT, NULL FIRST_NAME, NULL LAST_NAME, NULL FULL_NAME, NULL SUFFIX, NULL GROUP_NAME, PARTY.PARTY_NAME CUSTOMER_NAME, LOC.COUNTRY, LOC.ADDRESS1, LOC.ADDRESS2, LOC.ADDRESS3, LOC.ADDRESS4, LOC.CITY, LOC.POSTAL_CODE, LOC.STATE, LOC.PROVINCE, LOC.COUNTY FROM AS_SALES_CREDITS ASSC, HZ_PARTIES PARTY, HZ_LOCATIONS LOC, HZ_PARTY_SITES PARTY_SITE, OE_SALES_CREDIT_TYPES ASOSCTYPES WHERE ASSC.PARTNER_CUSTOMER_ID = PARTY.PARTY_ID AND ASSC.PARTNER_ADDRESS_ID = PARTY_SITE.PARTY_SITE_ID (+) AND LOC.LOCATION_ID (+) = PARTY_SITE.LOCATION_ID AND ASSC.CREDIT_TYPE_ID = ASOSCTYPES.SALES_CREDIT_TYPE_ID

View Text - HTML Formatted

SELECT ASSC.ROWID ROW_ID
, ASSC.SALES_CREDIT_ID
, ASSC.CREDIT_TYPE_ID
, ASOSCTYPES.NAME SALES_CREDIT_TYPE
, ASSC.LAST_UPDATE_DATE
, ASSC.LAST_UPDATED_BY
, ASSC.CREATION_DATE
, ASSC.CREATED_BY
, ASSC.LAST_UPDATE_LOGIN
, ASSC.REQUEST_ID
, ASSC.PROGRAM_APPLICATION_ID
, ASSC.PROGRAM_ID
, ASSC.PROGRAM_UPDATE_DATE
, ASSC.LEAD_ID
, ASSC.LEAD_LINE_ID
, ASSC.SALESFORCE_ID
, ASSC.PERSON_ID
, ASSC.SALESGROUP_ID
, ASSC.PARTNER_CUSTOMER_ID
, ASSC.PARTNER_ADDRESS_ID
, ASSC.DEFAULTED_FROM_OWNER_FLAG
, ASSC.ATTRIBUTE_CATEGORY
, ASSC.ATTRIBUTE1
, ASSC.ATTRIBUTE2
, ASSC.ATTRIBUTE3
, ASSC.ATTRIBUTE4
, ASSC.ATTRIBUTE5
, ASSC.ATTRIBUTE6
, ASSC.ATTRIBUTE7
, ASSC.ATTRIBUTE8
, ASSC.ATTRIBUTE9
, ASSC.ATTRIBUTE10
, ASSC.ATTRIBUTE11
, ASSC.ATTRIBUTE12
, ASSC.ATTRIBUTE13
, ASSC.ATTRIBUTE14
, ASSC.ATTRIBUTE15
, ASSC.CREDIT_PERCENT
, ASSC.CREDIT_AMOUNT
, ASSC.OPP_WORST_FORECAST_AMOUNT
, ASSC.OPP_FORECAST_AMOUNT
, ASSC.OPP_BEST_FORECAST_AMOUNT
, RS.SOURCE_FIRST_NAME FIRST_NAME
, RS.SOURCE_LAST_NAME LAST_NAME
, RS.SOURCE_NAME FULL_NAME
, NULL SUFFIX
, JTFRSG.GROUP_NAME
, NULL CUSTOMER_NAME
, NULL COUNTRY
, NULL ADDRESS1
, NULL ADDRESS2
, NULL ADDRESS3
, NULL ADDRESS4
, NULL CITY
, NULL POSTAL_CODE
, NULL STATE
, NULL PROVINCE
, NULL COUNTY
FROM AS_SALES_CREDITS ASSC
, JTF_RS_RESOURCE_EXTNS RS
, JTF_RS_GROUPS_TL JTFRSG
, OE_SALES_CREDIT_TYPES ASOSCTYPES
WHERE ASSC.SALESGROUP_ID = JTFRSG.GROUP_ID(+)
AND JTFRSG.LANGUAGE (+) = USERENV('LANG')
AND ASSC.CREDIT_TYPE_ID = ASOSCTYPES.SALES_CREDIT_TYPE_ID
AND ASSC.SALESFORCE_ID = RS.RESOURCE_ID
AND RS.CATEGORY = 'EMPLOYEE' UNION ALL SELECT ASSC.ROWID ROW_ID
, ASSC.SALES_CREDIT_ID
, ASSC.CREDIT_TYPE_ID
, ASOSCTYPES.NAME SALES_CREDIT_TYPE
, ASSC.LAST_UPDATE_DATE
, ASSC.LAST_UPDATED_BY
, ASSC.CREATION_DATE
, ASSC.CREATED_BY
, ASSC.LAST_UPDATE_LOGIN
, ASSC.REQUEST_ID
, ASSC.PROGRAM_APPLICATION_ID
, ASSC.PROGRAM_ID
, ASSC.PROGRAM_UPDATE_DATE
, ASSC.LEAD_ID
, ASSC.LEAD_LINE_ID
, ASSC.SALESFORCE_ID
, ASSC.PERSON_ID
, ASSC.SALESGROUP_ID
, ASSC.PARTNER_CUSTOMER_ID
, ASSC.PARTNER_ADDRESS_ID
, ASSC.DEFAULTED_FROM_OWNER_FLAG
, ASSC.ATTRIBUTE_CATEGORY
, ASSC.ATTRIBUTE1
, ASSC.ATTRIBUTE2
, ASSC.ATTRIBUTE3
, ASSC.ATTRIBUTE4
, ASSC.ATTRIBUTE5
, ASSC.ATTRIBUTE6
, ASSC.ATTRIBUTE7
, ASSC.ATTRIBUTE8
, ASSC.ATTRIBUTE9
, ASSC.ATTRIBUTE10
, ASSC.ATTRIBUTE11
, ASSC.ATTRIBUTE12
, ASSC.ATTRIBUTE13
, ASSC.ATTRIBUTE14
, ASSC.ATTRIBUTE15
, ASSC.CREDIT_PERCENT
, ASSC.CREDIT_AMOUNT
, ASSC.OPP_WORST_FORECAST_AMOUNT
, ASSC.OPP_FORECAST_AMOUNT
, ASSC.OPP_BEST_FORECAST_AMOUNT
, NULL FIRST_NAME
, NULL LAST_NAME
, NULL FULL_NAME
, NULL SUFFIX
, NULL GROUP_NAME
, PARTY.PARTY_NAME CUSTOMER_NAME
, LOC.COUNTRY
, LOC.ADDRESS1
, LOC.ADDRESS2
, LOC.ADDRESS3
, LOC.ADDRESS4
, LOC.CITY
, LOC.POSTAL_CODE
, LOC.STATE
, LOC.PROVINCE
, LOC.COUNTY
FROM AS_SALES_CREDITS ASSC
, HZ_PARTIES PARTY
, HZ_LOCATIONS LOC
, HZ_PARTY_SITES PARTY_SITE
, OE_SALES_CREDIT_TYPES ASOSCTYPES
WHERE ASSC.PARTNER_CUSTOMER_ID = PARTY.PARTY_ID
AND ASSC.PARTNER_ADDRESS_ID = PARTY_SITE.PARTY_SITE_ID (+)
AND LOC.LOCATION_ID (+) = PARTY_SITE.LOCATION_ID
AND ASSC.CREDIT_TYPE_ID = ASOSCTYPES.SALES_CREDIT_TYPE_ID