Product: | ASO - Order Capture |
---|---|
Description: | |
Implementation/DBA Data: | APPS.ASO_SALES_CREDITS_V |
SELECT SC.ROWID
, SC.CREATION_DATE
, SC.CREATED_BY
, SC.LAST_UPDATED_BY
, SC.LAST_UPDATE_DATE
, SC.LAST_UPDATE_LOGIN
, SC.REQUEST_ID
, SC.PROGRAM_APPLICATION_ID
, SC.PROGRAM_ID
, SC.PROGRAM_UPDATE_DATE
, SC.SALES_CREDIT_ID
, SC.QUOTE_HEADER_ID
, SC.QUOTE_LINE_ID
, SC.PERCENT
, SC.RESOURCE_ID
, RESRC.SALESREP_NUMBER
, NULL
, RESRC.NAME
, SC.RESOURCE_GROUP_ID
, GRP.GROUP_NUMBER
, GRP.GROUP_NAME
, GRP.GROUP_DESC
, GRP.EXCLUSIVE_FLAG
, SC.EMPLOYEE_PERSON_ID
, SC.SALES_CREDIT_TYPE_ID
, SC_TYPE.NAME
, SC_TYPE.DESCRIPTION
, SC_TYPE.QUOTA_FLAG
, SC.ATTRIBUTE_CATEGORY_CODE
, SC.ATTRIBUTE1
, SC.ATTRIBUTE2
, SC.ATTRIBUTE3
, SC.ATTRIBUTE4
, SC.ATTRIBUTE5
, SC.ATTRIBUTE6
, SC.ATTRIBUTE7
, SC.ATTRIBUTE8
, SC.ATTRIBUTE9
, SC.ATTRIBUTE10
, SC.ATTRIBUTE11
, SC.ATTRIBUTE12
, SC.ATTRIBUTE13
, SC.ATTRIBUTE14
, SC.ATTRIBUTE15
, SC.OBJECT_VERSION_NUMBER
FROM ASO_SALES_CREDITS SC
, ASO_I_SALES_CREDIT_TYPES_V SC_TYPE
, JTF_RS_SRP_VL RESRC
, JTF_RS_GROUPS_VL GRP
WHERE SC.SALES_CREDIT_TYPE_ID = SC_TYPE.SALES_CREDIT_TYPE_ID
AND SC.RESOURCE_ID = RESRC.RESOURCE_ID
AND SC.RESOURCE_GROUP_ID = GRP.GROUP_ID (+)
AND RESRC.STATUS = 'A'
AND (TRUNC(NVL(RESRC.START_DATE_ACTIVE
, SYSDATE)) <= TRUNC(SYSDATE))
AND (TRUNC(NVL(RESRC.END_DATE_ACTIVE
, SYSDATE)) >= TRUNC(SYSDATE))
AND NVL(RESRC.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO' )
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)