VIEW: APPS.PA_CC_TP_BILL_SCH_ORG_V

Source

View Text - Preformatted

SELECT distinct o.name, b.schedule_type, b.org_id, sob.currency_code FROM pa_std_bill_rate_schedules_all b, hr_operating_units o, pa_implementations_all iall, gl_sets_of_books sob WHERE nvl(b.org_id,-99) = o.organization_id AND nvl(iall.org_id,-99) = o.organization_id AND iall.set_of_books_id = sob.set_of_books_id AND ( ( iall.business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID') and pa_cross_business_grp.IsCrossBGProfile='N') OR pa_cross_business_grp.IsCrossBGProfile='Y')

View Text - HTML Formatted

SELECT DISTINCT O.NAME
, B.SCHEDULE_TYPE
, B.ORG_ID
, SOB.CURRENCY_CODE
FROM PA_STD_BILL_RATE_SCHEDULES_ALL B
, HR_OPERATING_UNITS O
, PA_IMPLEMENTATIONS_ALL IALL
, GL_SETS_OF_BOOKS SOB
WHERE NVL(B.ORG_ID
, -99) = O.ORGANIZATION_ID
AND NVL(IALL.ORG_ID
, -99) = O.ORGANIZATION_ID
AND IALL.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
AND ( ( IALL.BUSINESS_GROUP_ID = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
AND PA_CROSS_BUSINESS_GRP.ISCROSSBGPROFILE='N') OR PA_CROSS_BUSINESS_GRP.ISCROSSBGPROFILE='Y')