PA Implementation Options

Description
Categories: BI Publisher, Financials
Application: Projects
Source: IMP: Implementation Options (XML)
Short Name: PAXRWIMP_XML
DB package: PA_PAXRWIMP_XMLP_PKG
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'