VIEW: APPS.PA_CC_TP_RULES_V

Source

View Text - Preformatted

SELECT r1.rowid, r1.tp_rule_id, r1.business_group_id, r1.name, r1.rule_type, r1.markup_calc_base_code, r1.calc_method_code, r1.percentage_applied, r1.start_date_active, r1.last_update_date, r1.last_updated_by, r1.creation_date, r1.created_by, r1.last_update_login, r1.end_date_active, r1.description, r1.schedule_id, NULL, NULL, NULL, NULL, r1.attribute_category, r1.attribute1, r1.attribute2, r1.attribute3, r1.attribute4, r1.attribute5, r1.attribute6, r1.attribute7, r1.attribute8, r1.attribute9, r1.attribute10, r1.attribute11, r1.attribute12, r1.attribute13, r1.attribute14, r1.attribute15 FROM PA_CC_TP_RULES r1 WHERE r1.schedule_id is null and r1.calc_method_code='A' UNION ALL SELECT r1.rowid, r1.tp_rule_id, r1.business_group_id, r1.name, r1.rule_type, r1.markup_calc_base_code, r1.calc_method_code, r1.percentage_applied, r1.start_date_active, r1.last_update_date, r1.last_updated_by, r1.creation_date, r1.created_by, r1.last_update_login, r1.end_date_active, r1.description, r1.schedule_id, NULL, NULL, NULL, s.ind_rate_sch_name, r1.attribute_category, r1.attribute1, r1.attribute2, r1.attribute3, r1.attribute4, r1.attribute5, r1.attribute6, r1.attribute7, r1.attribute8, r1.attribute9, r1.attribute10, r1.attribute11, r1.attribute12, r1.attribute13, r1.attribute14, r1.attribute15 FROM PA_CC_TP_RULES r1, PA_IND_RATE_SCHEDULES s WHERE r1.schedule_id=s.ind_rate_sch_id and r1.calc_method_code='B' UNION ALL SELECT r1.rowid, r1.tp_rule_id, r1.business_group_id, r1.name, r1.rule_type, r1.markup_calc_base_code, r1.calc_method_code, r1.percentage_applied, r1.start_date_active, r1.last_update_date, r1.last_updated_by, r1.creation_date, r1.created_by, r1.last_update_login, r1.end_date_active, r1.description, r1.schedule_id, h1.name, h2.name, b.std_bill_rate_schedule, null, r1.attribute_category, r1.attribute1, r1.attribute2, r1.attribute3, r1.attribute4, r1.attribute5, r1.attribute6, r1.attribute7, r1.attribute8, r1.attribute9, r1.attribute10, r1.attribute11, r1.attribute12, r1.attribute13, r1.attribute14, r1.attribute15 FROM PA_CC_TP_RULES r1, PA_STD_BILL_RATE_SCHEDULES_ALL b, hr_operating_units h1, hr_organization_units h2 WHERE r1.schedule_id= b.bill_rate_sch_id AND b.organization_id=h2.organization_id AND nvl(b.org_id,-99)=h1.organization_id AND r1.calc_method_code ='R'

View Text - HTML Formatted

SELECT R1.ROWID
, R1.TP_RULE_ID
, R1.BUSINESS_GROUP_ID
, R1.NAME
, R1.RULE_TYPE
, R1.MARKUP_CALC_BASE_CODE
, R1.CALC_METHOD_CODE
, R1.PERCENTAGE_APPLIED
, R1.START_DATE_ACTIVE
, R1.LAST_UPDATE_DATE
, R1.LAST_UPDATED_BY
, R1.CREATION_DATE
, R1.CREATED_BY
, R1.LAST_UPDATE_LOGIN
, R1.END_DATE_ACTIVE
, R1.DESCRIPTION
, R1.SCHEDULE_ID
, NULL
, NULL
, NULL
, NULL
, R1.ATTRIBUTE_CATEGORY
, R1.ATTRIBUTE1
, R1.ATTRIBUTE2
, R1.ATTRIBUTE3
, R1.ATTRIBUTE4
, R1.ATTRIBUTE5
, R1.ATTRIBUTE6
, R1.ATTRIBUTE7
, R1.ATTRIBUTE8
, R1.ATTRIBUTE9
, R1.ATTRIBUTE10
, R1.ATTRIBUTE11
, R1.ATTRIBUTE12
, R1.ATTRIBUTE13
, R1.ATTRIBUTE14
, R1.ATTRIBUTE15
FROM PA_CC_TP_RULES R1
WHERE R1.SCHEDULE_ID IS NULL
AND R1.CALC_METHOD_CODE='A' UNION ALL SELECT R1.ROWID
, R1.TP_RULE_ID
, R1.BUSINESS_GROUP_ID
, R1.NAME
, R1.RULE_TYPE
, R1.MARKUP_CALC_BASE_CODE
, R1.CALC_METHOD_CODE
, R1.PERCENTAGE_APPLIED
, R1.START_DATE_ACTIVE
, R1.LAST_UPDATE_DATE
, R1.LAST_UPDATED_BY
, R1.CREATION_DATE
, R1.CREATED_BY
, R1.LAST_UPDATE_LOGIN
, R1.END_DATE_ACTIVE
, R1.DESCRIPTION
, R1.SCHEDULE_ID
, NULL
, NULL
, NULL
, S.IND_RATE_SCH_NAME
, R1.ATTRIBUTE_CATEGORY
, R1.ATTRIBUTE1
, R1.ATTRIBUTE2
, R1.ATTRIBUTE3
, R1.ATTRIBUTE4
, R1.ATTRIBUTE5
, R1.ATTRIBUTE6
, R1.ATTRIBUTE7
, R1.ATTRIBUTE8
, R1.ATTRIBUTE9
, R1.ATTRIBUTE10
, R1.ATTRIBUTE11
, R1.ATTRIBUTE12
, R1.ATTRIBUTE13
, R1.ATTRIBUTE14
, R1.ATTRIBUTE15
FROM PA_CC_TP_RULES R1
, PA_IND_RATE_SCHEDULES S
WHERE R1.SCHEDULE_ID=S.IND_RATE_SCH_ID
AND R1.CALC_METHOD_CODE='B' UNION ALL SELECT R1.ROWID
, R1.TP_RULE_ID
, R1.BUSINESS_GROUP_ID
, R1.NAME
, R1.RULE_TYPE
, R1.MARKUP_CALC_BASE_CODE
, R1.CALC_METHOD_CODE
, R1.PERCENTAGE_APPLIED
, R1.START_DATE_ACTIVE
, R1.LAST_UPDATE_DATE
, R1.LAST_UPDATED_BY
, R1.CREATION_DATE
, R1.CREATED_BY
, R1.LAST_UPDATE_LOGIN
, R1.END_DATE_ACTIVE
, R1.DESCRIPTION
, R1.SCHEDULE_ID
, H1.NAME
, H2.NAME
, B.STD_BILL_RATE_SCHEDULE
, NULL
, R1.ATTRIBUTE_CATEGORY
, R1.ATTRIBUTE1
, R1.ATTRIBUTE2
, R1.ATTRIBUTE3
, R1.ATTRIBUTE4
, R1.ATTRIBUTE5
, R1.ATTRIBUTE6
, R1.ATTRIBUTE7
, R1.ATTRIBUTE8
, R1.ATTRIBUTE9
, R1.ATTRIBUTE10
, R1.ATTRIBUTE11
, R1.ATTRIBUTE12
, R1.ATTRIBUTE13
, R1.ATTRIBUTE14
, R1.ATTRIBUTE15
FROM PA_CC_TP_RULES R1
, PA_STD_BILL_RATE_SCHEDULES_ALL B
, HR_OPERATING_UNITS H1
, HR_ORGANIZATION_UNITS H2
WHERE R1.SCHEDULE_ID= B.BILL_RATE_SCH_ID
AND B.ORGANIZATION_ID=H2.ORGANIZATION_ID
AND NVL(B.ORG_ID
, -99)=H1.ORGANIZATION_ID
AND R1.CALC_METHOD_CODE ='R'