SELECT
GSOB.name Name
, substr(BG.name,1,60) Bgroup
, POS.name Org_stru
, V.version_number Org_ver
, substr(TORG.name ,1,60) Top_org
, ERDT.meaning Exch_rate_date_type
, PI.default_rate_type Exch_rate_type
, PI.enable_mrc_for_fund_flag Mrc_for_Fund
, PI.reval_mrc_funding_flag reval_Mrc_Fund
, PI.enable_mrc_for_finplan_flag Mrc_for_Finplan
, FP.meaning Finplan_Mrc
, PI.include_gains_losses_flag Ingainloss
, NUM.meaning Number_entry
, DECODE(PI.user_defined_project_num_code,'AUTOMATIC',
NVL(U.next_unique_identifier ,''), '') Automatic_project_number
, ENT.meaning Number_type
, POS2.name Proj_stru
, V2.version_number Proj_ver
, substr(TORG2.name,1,60) Proj_org
, EXP.meaning Exp_cycle
, PI.overtime_calc_enabled_flag Overtime_flag
, POS1.name Exp_stru
, V1.version_number Exp_ver
, substr(TORG1.name,1,60) Exp_org
, PI.interface_labor_to_gl_flag Iflabortogl
, PI.interface_usage_to_gl_flag Ifusagetogl
, PI.interface_revenue_to_gl_flag Ifrevenuetogl
, PI.retn_accounting_flag Ifretnacc
, INVNUM.meaning Invoice_number_entry
, INVENT.meaning Invoice_number_type
, DECODE(PI.user_defined_invoice_num_code,'AUTOMATIC',
PI.next_automatic_invoice_number, '') Automatic_invoice_number
, RBS2.name Invoice_batch_source
, PI.SALES_CREDIT_TYPE_CODE , PI.CUST_ACC_REL_CODE
, PI.CREDIT_MEMO_REASON_FLAG
, PI.accumulation_period_type Glpa_type
, CINV.meaning central_invoicing_flag
, MULTI.meaning multi_currency_billing_flag
, SHR.meaning share_across_ou_flag
, FUND.meaning allow_funding_flag
, centralized_invoicing_flag
,RATE.meaning rate_disc_reason_flag
,BILL.meaning br_override_flag
,BILDIS.meaning br_discount_over_flag
,PI.book_type_code book_type_code
,PA_PAXRWIMP_XMLP_PKG.cf_customer_relationformula(PI.CUST_ACC_REL_CODE) CF_customer_relation
,PA_PAXRWIMP_XMLP_PKG.cf_credit_memoformula(PI.CREDIT_MEMO_REASON_FLAG) CF_credit_memo
,PA_PAXRWIMP_XMLP_PKG.cf_ifretnaccformul(PI.retn_accounting_flag) CF_retnacc
,PA_PAXRWIMP_XMLP_PKG.cf_mrc_for_fundformula(PI.enable_mrc_for_fund_flag) CF_mrc_for_fund
,PA_PAXRWIMP_XMLP_PKG.cf_reval_mrc_fundformula(PI.reval_mrc_funding_flag) CF_reval_mrc_fund
,PA_PAXRWIMP_XMLP_PKG.cf_mrc_for_finplanformula(PI.enable_mrc_for_finplan_flag) CF_mrc_for_finplan
,PA_PAXRWIMP_XMLP_PKG.cf_ingainlossformula(PI.include_gains_losses_flag) CF_ingainloss
,PA_PAXRWIMP_XMLP_PKG.cf_overtime_flagformula(PI.overtime_calc_enabled_flag) CF_over_flag
,PA_PAXRWIMP_XMLP_PKG.cf_iflabortoglformula(PI.interface_labor_to_gl_flag) CF_Iflabortogl
,PA_PAXRWIMP_XMLP_PKG.cf_ifrevtoglformula(PI.interface_revenue_to_gl_flag) CF_ifrevtogl
,PA_PAXRWIMP_XMLP_PKG.cf_ifusgtoglformula(PI.interface_usage_to_gl_flag) CF_ifusgtogl
,PA_PAXRWIMP_XMLP_PKG.c_descformula(PI.accumulation_period_type) C_desc
,PA_PAXRWIMP_XMLP_PKG.cf_cen_inv_collformula(centralized_invoicing_flag) CF_Cen_Inv_Coll
,PA_PAXRWIMP_XMLP_PKG.CF_exch_rate_typeFormula(PI.default_rate_type) CF_exch_rate_type
FROM
ra_batch_sources RBS2
, pa_unique_identifier_control U
, gl_sets_of_books GSOB
, pa_lookups INVNUM
, pa_lookups INVENT
, pa_lookups NUM
, pa_lookups ENT
, pa_lookups EXP
, pa_lookups ERDT
, pa_lookups FP , fnd_lookups MULTI
, fnd_lookups SHR
, fnd_lookups FUND
, fnd_lookups CINV
, fnd_lookups RATE , fnd_lookups BILL , fnd_lookups BILDIS , hr_organization_units BG
, hr_organization_units TORG
, hr_organization_units TORG1
, hr_organization_units TORG2
, per_organization_structures POS
, per_organization_structures POS1
, per_organization_structures POS2
, pa_implementations PI
, per_org_structure_versions V
, per_org_structure_versions V1
, per_org_structure_versions V2
where
RBS2.batch_source_id(+) = PI.invoice_batch_source_id
and PI.set_of_books_id = GSOB.set_of_books_id
and PI.business_group_id = BG.organization_id
and PI.start_organization_id = TORG.organization_id
and PI.exp_start_org_id = TORG1.organization_id
and PI.proj_start_org_id = TORG2.organization_id
and PI.organization_structure_id = POS.organization_structure_id
and PI.exp_org_structure_id = POS1.organization_structure_id
and PI.proj_org_structure_id = POS2.organization_Structure_id
and PI.user_defined_project_num_code = NUM.lookup_code
and PI.user_defined_invoice_num_code = INVNUM.lookup_code(+)
and NUM.lookup_type = 'PROJECT NUMBER ENTRY'
and INVNUM.lookup_type(+) = 'INVOICE NUMBER ENTRY'
and PI.manual_project_num_type = ENT.lookup_code
and ENT.lookup_type = 'MANUAL PROJECT NUMBER'
and PI.manual_invoice_num_type = INVENT.lookup_code(+)
and INVENT.lookup_type(+) = 'MANUAL INVOICE NUMBER'
and PI.exp_cycle_start_day_code = EXP.lookup_code
and EXP.lookup_type = 'EXPENDITURE CYCLE START DAY'
and PI.default_rate_date_code = ERDT.lookup_code
and ERDT.lookup_type = 'RATE_DATE_CODE'
and PI.finplan_mrc_option_code = FP.lookup_code(+)
and FP.lookup_type(+) = 'PA_FP_MRC_OPTION_CODE'
and U.table_name = 'PA_PROJECTS'
and PI.organization_structure_id = V.organization_structure_id
and PI.org_structure_version_id = V.org_structure_version_id
and PI.exp_org_structure_id = V1.organization_structure_id
and PI.exp_org_structure_version_id = V1.org_structure_version_id
and PI.proj_org_structure_id = V2.organization_structure_id
and PI.proj_org_structure_version_id = V2.org_structure_version_id
and PI.multi_currency_billing_flag = MULTI.lookup_code(+)
and MULTI.lookup_type(+)='YES_NO'
and PI.share_across_ou_br_sch_flag = SHR.lookup_code(+)
and SHR.lookup_type(+)='YES_NO'
and PI.allow_funding_across_ou_flag =FUND.lookup_code(+)
and FUND.lookup_type(+)='YES_NO'
and PI.centralized_invoicing_flag =CINV.lookup_code(+)
and CINV.lookup_type(+)='YES_NO'
and PI.rate_discount_reason_flag=RATE.lookup_code(+)
and RATE.lookup_type(+)='YES_NO'
and PI.br_override_flag=BILL.lookup_code(+)
and BILL.lookup_type(+)='YES_NO'
and PI.br_discount_override_flag=BILDIS.lookup_code(+)
and BILDIS.lookup_type(+)='YES_NO' |
