Product: | FII - Financial Intelligence |
---|---|
Description: | Internal view |
Implementation/DBA Data: | APPS.FII_LOB_ASSIGNMENTS_V |
SELECT LOB.ROWID ROW_ID
, LOB.LINE_OF_BUSINESS LINE_OF_BUSINESS
, LOB.COMPANY_COST_CENTER_ORG_ID COMPANY_COST_CENTER_ORG_ID
, HRCC.NAME COMPANY_CC_ORG_NAME
, HRCC.COMPANY_CODE COMPANY_CODE
, HRCC.COMPANY_VS COMPANY_VS
, HRCC.COST_CENTER_CODE COST_CENTER_CODE
, HRCC.COST_CENTER_VS COST_CENTER_VS
, HRCC.CONC_COMPANY_CC_SEGMENTS DESCRIPTION
, LOB.CREATION_DATE CREATION_DATE
, LOB.CREATED_BY CREATED_BY
, LOB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, LOB.LAST_UPDATED_BY LAST_UPDATED_BY
, LOB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM FII_LOB_ASSIGNMENTS LOB
, HR_COMPANY_COST_CENTERS HRCC
WHERE LOB.COMPANY_COST_CENTER_ORG_ID = HRCC.ORGANIZATION_ID