FND Design Data [Home] [Help]

View: PA_CC_TP_RULES

Product: PA - Projects
Description:
Implementation/DBA Data: ViewAPPS.PA_CC_TP_RULES
View Text

SELECT TP_RULE_ID
, BUSINESS_GROUP_ID
, NAME
, RULE_TYPE
, MARKUP_CALC_BASE_CODE
, CALC_METHOD_CODE
, PERCENTAGE_APPLIED
, START_DATE_ACTIVE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, END_DATE_ACTIVE
, DESCRIPTION
, SCHEDULE_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15 FROM PA_CC_TP_RULES_BG
WHERE ((BUSINESS_GROUP_ID = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
AND PA_CROSS_BUSINESS_GRP.ISCROSSBGPROFILE='N') OR PA_CROSS_BUSINESS_GRP.ISCROSSBGPROFILE ='Y')

Columns

Name
TP_RULE_ID
BUSINESS_GROUP_ID
NAME
RULE_TYPE
MARKUP_CALC_BASE_CODE
CALC_METHOD_CODE
PERCENTAGE_APPLIED
START_DATE_ACTIVE
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
END_DATE_ACTIVE
DESCRIPTION
SCHEDULE_ID
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15