View: PA_CC_TP_BILL_SCH_ORG_V

Product:	PA - Projects
Description:	PA_CC_TP_BILL_SCH_ORG_V provides bill schedule operating unit information within a business group
Implementation/DBA Data:	APPS.PA_CC_TP_BILL_SCH_ORG_V

View Text

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')

Columns