1. Tables and Views for Project Management
  2. PJF_PROJECT_CURRENCY_DETAILS_V

PJF_PROJECT_CURRENCY_DETAILS_V

Details

  • Schema: FUSION

  • Object owner: PJF

  • Object type: VIEW

Columns

Name

BU_ID

PROJECT_ID

LEDGER_CURRENCY_CODE

LEDGER_RATE_TYPE

LEDGER_RATE_DATE_CODE

PROJECT_CURRENCY_CODE

PROJECT_RATE_TYPE

PROJECT_RATE_DATE_CODE

PROJECT_RATE_DATE

Query

SQL_Statement

SELECT proj.org_id bu_id,

project_id,

ledgers.currency_code Ledger_currency_code,

buimpl. DEFAULT_RATE_TYPE Ledger_rate_type,

buimpl. DEFAULT_RATE_DATE_CODE Ledger_rate_date_code,

Project_currency_code,

currency_conv_rate_type Project_rate_type,

currency_conv_date_type_code Project_rate_date_code,

currency_conv_date Project_rate_date

FROM Pjf_projects_all_b proj,

pjf_bu_impl_all buimpl,

HR_ORGANIZATION_INFORMATION_X INFO,

gl_ledgers ledgers

WHERE proj.org_id = buimpl.org_id

AND buimpl.org_id = INFO.ORGANIZATION_ID

AND INFO.ORG_INFORMATION_CONTEXT = 'FUN_BUSINESS_UNIT'

AND ledgers.ledger_id = INFO.ORG_INFORMATION3

AND proj.project_category ='FIN_EXEC'