PA Implementation Options
Description
Categories: BI Publisher
Application: Projects
Source: IMP: Implementation Options (XML)
Short Name: PAXRWIMP_XML
DB package: PA_PAXRWIMP_XMLP_PKG
Source: IMP: Implementation Options (XML)
Short Name: PAXRWIMP_XML
DB package: PA_PAXRWIMP_XMLP_PKG
Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS
Contact us to schedule a demo or if you need help with the installation
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' |