VIEW: APPS.JAI_CMN_RG_BALANCES_V

Source

View Text - Preformatted

SELECT ja1.ROWID row_id, ja1.org_unit_id, ja1.organization_id, ja1.location_id , ja1.pla_balance, ja1.rg23a_balance, ja1.rg23c_balance, ja1.creation_date, ja1.created_by, ja1.last_updated_by, ja1.last_update_login, ja1.last_update_date, org.organization_name, loc.location_code, cur.currency_code, ja1.basic_pla_balance, ja1.additional_pla_balance, ja1.other_pla_balance FROM org_organization_definitions org, JAI_CMN_RG_BALANCES ja1, hr_locations loc, fnd_currencies cur, gl_sets_of_books gl, JAI_CMN_INVENTORY_ORGS hou WHERE ja1.organization_id = org.organization_id AND loc.location_id (+)= ja1.location_id AND cur.currency_code = gl.currency_code AND gl.set_of_books_id = org.set_of_books_id AND ja1.org_unit_id = hou.org_unit_id AND NVL(hou.TRADING,'N') <> 'Y'

View Text - HTML Formatted

SELECT JA1.ROWID ROW_ID
, JA1.ORG_UNIT_ID
, JA1.ORGANIZATION_ID
, JA1.LOCATION_ID
, JA1.PLA_BALANCE
, JA1.RG23A_BALANCE
, JA1.RG23C_BALANCE
, JA1.CREATION_DATE
, JA1.CREATED_BY
, JA1.LAST_UPDATED_BY
, JA1.LAST_UPDATE_LOGIN
, JA1.LAST_UPDATE_DATE
, ORG.ORGANIZATION_NAME
, LOC.LOCATION_CODE
, CUR.CURRENCY_CODE
, JA1.BASIC_PLA_BALANCE
, JA1.ADDITIONAL_PLA_BALANCE
, JA1.OTHER_PLA_BALANCE
FROM ORG_ORGANIZATION_DEFINITIONS ORG
, JAI_CMN_RG_BALANCES JA1
, HR_LOCATIONS LOC
, FND_CURRENCIES CUR
, GL_SETS_OF_BOOKS GL
, JAI_CMN_INVENTORY_ORGS HOU
WHERE JA1.ORGANIZATION_ID = ORG.ORGANIZATION_ID
AND LOC.LOCATION_ID (+)= JA1.LOCATION_ID
AND CUR.CURRENCY_CODE = GL.CURRENCY_CODE
AND GL.SET_OF_BOOKS_ID = ORG.SET_OF_BOOKS_ID
AND JA1.ORG_UNIT_ID = HOU.ORG_UNIT_ID
AND NVL(HOU.TRADING
, 'N') <> 'Y'