Product: | AS - Sales Foundation |
---|---|
Description: | Provide details about sales credits for an opportunity |
Implementation/DBA Data: | APPS.AS_SALES_CREDITS_V |
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.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
, 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.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
, 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