VIEW: APPS.PA_IND_RATE_SCHEDULES

Source

View Text - Preformatted

SELECT IND_RATE_SCH_ID ,IND_RATE_SCH_NAME ,DESCRIPTION ,START_DATE_ACTIVE ,END_DATE_ACTIVE ,LAST_UPDATE_DATE ,LAST_UPDATED_BY ,CREATED_BY ,CREATION_DATE ,LAST_UPDATE_LOGIN ,COST_PLUS_STRUCTURE ,IND_RATE_SCHEDULE_TYPE ,PROJECT_ID ,TASK_ID ,COST_OVR_SCH_FLAG ,REV_OVR_SCH_FLAG ,INV_OVR_SCH_FLAG ,BUSINESS_GROUP_ID ,ORGANIZATION_STRUCTURE_ID ,ORG_STRUCTURE_VERSION_ID ,START_ORGANIZATION_ID ,IND_RATE_SCH_USAGE FROM PA_IND_RATE_SCHEDULES_ALL_BG A WHERE (( a.business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID') AND PA_UTILS.IsCrossBGProfile_WNPS='N') OR PA_UTILS.IsCrossBGProfile_WNPS ='Y')

View Text - HTML Formatted

SELECT IND_RATE_SCH_ID
, IND_RATE_SCH_NAME
, DESCRIPTION
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, COST_PLUS_STRUCTURE
, IND_RATE_SCHEDULE_TYPE
, PROJECT_ID
, TASK_ID
, COST_OVR_SCH_FLAG
, REV_OVR_SCH_FLAG
, INV_OVR_SCH_FLAG
, BUSINESS_GROUP_ID
, ORGANIZATION_STRUCTURE_ID
, ORG_STRUCTURE_VERSION_ID
, START_ORGANIZATION_ID
, IND_RATE_SCH_USAGE
FROM PA_IND_RATE_SCHEDULES_ALL_BG A
WHERE (( A.BUSINESS_GROUP_ID = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
AND PA_UTILS.ISCROSSBGPROFILE_WNPS='N') OR PA_UTILS.ISCROSSBGPROFILE_WNPS ='Y')