Query To Display All Forms and Pages for a Responsibility In Oracle Applications R12

SELECT  fmev.prompt , user_function_name,type

FROM (SELECT * FROM fnd_menu_entries_vl WHERE prompt is not null and grant_flag ='Y' ) fmev

    , fnd_form_functions_vl ffv

WHERE fmev.function_id is not null

AND   fmev.sub_menu_id is null

AND  fmev.function_id = ffv.function_id(+)

AND  ffv.type NOT IN ( 'SUBFUNCTION')

CONNECT BY PRIOR sub_menu_id = menu_id

START WITH menu_id in(

SELECT menu_id

FROM fnd_responsibility_vl fv

WHERE fv.responsibility_name like :P_Responsibility_name

) 

Query to Display Finanial Options Details In Oracle Applications R12

Hi All,

To Check Details in Front End Go To Payables Responsibility then click on Setup and then click on Options and Payables Options.

SELECT hou.name "Operating Unit"
,fsp.future_period_limit
,gcck.concatenated_segments "Liability"
,gcck2.concatenated_segments "Prepayment"
,gcck3.concatenated_segments "Bills Payable"
,gcck4.concatenated_segments "Discount Taken"
,gcck5.concatenated_segments "PO Rate Variance Gain"
,gcck6.concatenated_segments "PO Rate Variance Loss"
,gcck7.concatenated_segments "Expenses Clearing"
,gcck8.concatenated_segments "Miscellaneous"
,gcck9.concatenated_segments "Retainage"
,fsp.rfq_only_site_flag "RFQ Only Site"
,plvv.location_code "Ship-To Location"
,plvv2.location_code "Bill-To Location"
,ood.organization_code||' - '||ood.organization_name "Inventory Organization"
,fsp.ship_via_lookup_code "Ship Via"
,fsp.fob_lookup_code "FOB"
,fsp.freight_terms_lookup_code "Freight Terms"
,fsp.req_encumbrance_flag "Use Requisition Encumbrance"
,fsp.reserve_at_completion_flag "Reserve at Completion"
,fsp.purch_encumbrance_flag "Use PO Encumbrance"
,fsp.vat_country_code "Member State"
,fsp.vat_registration_num "VAT Registration Number"
,hbg.business_group_name "Business Group"
,decode(fsp.expense_check_address_flag,'H','Home','O','Office','P','Provisional') "Expense Reimbursement Address"
,fsp.use_positions_flag "Use Approval Hierarchies"
FROM FINANCIALS_SYSTEM_PARAMS_ALL fsp
,hr_operating_units hou
,gl_code_combinations_kfv gcck
,gl_code_combinations_kfv gcck2
,gl_code_combinations_kfv gcck3
,gl_code_combinations_kfv gcck4
,gl_code_combinations_kfv gcck5
,gl_code_combinations_kfv gcck6
,gl_code_combinations_kfv gcck7
,gl_code_combinations_kfv gcck8
,gl_code_combinations_kfv gcck9
,po_locations_val_v plvv
,po_locations_val_v plvv2
,org_organization_definitions ood
,hrfv_business_groups hbg
WHERE 1=1
AND fsp.org_id=hou.organization_id
AND hou.organization_id=nvl(:P_ORG_ID,hou.organization_id)
AND fsp.accts_pay_code_combination_id=gcck.code_combination_id
AND fsp.prepay_code_combination_id=gcck2.code_combination_id
AND fsp.future_dated_payment_ccid=gcck3.code_combination_id(+)
AND fsp.disc_taken_code_combination_id=gcck4.code_combination_id
AND fsp.rate_var_gain_ccid=gcck5.code_combination_id
AND fsp.rate_var_loss_ccid=gcck6.code_combination_id
AND fsp.expense_clearing_ccid=gcck7.code_combination_id(+)
AND fsp.misc_charge_ccid=gcck8.code_combination_id(+)
AND fsp.retainage_code_combination_id=gcck9.code_combination_id(+)
AND plvv.location_id(+)=fsp.ship_to_location_id
AND plvv2.location_id(+)=fsp.ship_to_location_id
AND ood.organization_id=fsp.inventory_organization_id
AND fsp.business_group_id=hbg.business_group_id

Query to Display Payables Options Details In Oracle Applications R12

To Check Details in Front End Go To Payables Responsibility then click on Setup and then click on Options and Payables Options.

SELECT hou.name "Operating unit"
-------Accounting Option Tab Details--------------------------------------------
,aspa.when_to_account_pmt "When Payment is Issued" --Account For Payment
,aspa.recon_accounting_flag "When Payment Clears" --Account For Payment
,aspa.when_to_account_gain_loss "When Payment Is Issued" --Account For Gain/Loss
,aspa.recon_accounting_flag "When Payment Clears2" --Account For Gain/Loss
,aspa.future_dated_pmt_acct_source "Bills Payable Account Source"
,aspa.liability_post_lookup_code "Automatic Offset Method"
,aspa.discount_distribution_method "Discount Method"
,aspa.prorate_int_inv_across_dists "Interest"
,aspa.build_prepayment_accounts_flag "Prepayment Account"
-------Currency Tab Details-----------------------------------------------------
,aspa.multi_currency_flag "Use Multiple Currencies"
,aspa.make_rate_mandatory_flag "Require Exchange Rate Entry"
,aspa.calc_user_xrate "Calculate User Excange Rate"
,aspa.default_exchange_rate_type "Exchange Rate Type"
,gcck.concatenated_segments "Realized Gain"
,gcck2.concatenated_segments "Realized Loss"
,gcck3.concatenated_segments "Rounding"
-------Tax Reporting Tab Details------------------------------------------------
,aspa.combined_filing_flag "Combined Filing Program"
,aspa.income_tax_region_flag "Use Pay Site Tax Region"
,aspa.income_tax_region "Income Tax Region"
-------Invoice Tab Details------------------------------------------------------
,aspa.confirm_date_as_inv_num_flag "Confirm Date as Invoice Number"
,aspa.approvals_option "Allow Online Validation"
,aspa.inv_doc_category_override "Allow Document Catgry Override"
,aspa.allow_paid_invoice_adjust "Allow Adjustmts to Paid Invces"
,aspa.recalc_pay_schedule_flag "Recalculate Scheduled Payment"
,aspa.allow_supplier_bank_override "Allow Remit-To Acct Override"
,aspa.allow_inv_third_party_ovrd "Allow Remit-To Supplr Override"
,aspa.receipt_acceptance_days "Receipt Acceptance Days"
,aspa.gl_date_from_receipt_flag "GL Date Basis"
,gcck4.concatenated_segments "Freight Account"
,att.name " Pre Payment Terms"
,aspa.add_days_settlement_date "Settlement Days"
,gcck5.concatenated_segments "Tax Difference Account"
-------Approval Tab Details-----------------------------------------------------
,aspa.approval_workflow_flag "Use Invoice Approval Workflow"
,aspa.allow_force_approval_flag "Allow Force Approval"
,aspa.validate_before_approval_flag "Require Validtn Befr Approval"
,aspa.approval_timing "Require Accting Befr Approval"
-------Matching Tab Details-----------------------------------------------------
,aspa.allow_final_match_flag "Allow Final Matching"
,aspa.allow_dist_match_flag "Allow Distrbtn Level Matching"
,aspa.allow_flex_override_flag "Allow Matchng Acct Override"
,aspa.transfer_desc_flex_flag "Trnsf PO DFF Information"
,at.tolerance_name "Goods Tolerances"
,at2.tolerance_name "Services Tolerances"
-------Interest Tab Details-----------------------------------------------------
,aspa.auto_calculate_interest_flag "Allow Interest Invoices"
,aspa.interest_tolerance_amount "Minimum Interest Amount"
,gcck6.concatenated_segments "Expense"
,gcck7.concatenated_segments "Liability"
-------Expense Report Tab Details-----------------------------------------------
,aer.report_type "Default Template"
,aspa.apply_advances_default "Apply Advances"
,aspa.create_employee_vendor_flag "Automatclly Crate Emp as Supp"
,att2.name "Payment Terms"
,aspa.employee_pay_group_lookup_code "Pay Group"
,aspa.employee_payment_priority "Payment Priority"
,aspa.hold_unmatched_invoices_flag "Hold Unmatched Expense Reports"
-------Payment Tab Details-----------------------------------------------------
,aspa.disc_is_inv_less_tax_flag "Exclude Tax Frm Discnt Calcltn"
,aspa.post_dated_payments_flag "Allow Pre-Date"
,replace_check_flag "Allow Void and Reissue"
,aspa.update_pay_site_flag "Allow Address Change"
,aspa.use_bank_charge_flag "Enbl BankCharg Dedctn Frm Payt"
,aspa.bank_charge_bearer "Deduct Bank Charge Frm Paymt"
,aspa.allow_pymt_third_party_ovrd "Allow Remit-To Supplr Ovrride"
,aspa.pay_doc_category_override "Allow Document Category Ovrrde"
-------Withholding Tax Tab Details-----------------------------------------------------
,aspa.allow_awt_flag "Use Withholding Tax"
,aspa.allow_awt_override "Allow Manual Withholding"
,aag.name "Tax Group"
,aspa.awt_include_discount_amt "Include Discount Amount"
,aspa.awt_include_tax_amt "Include Tax Amount"
,aspa.create_awt_dists_type "Apply Withholding Tax"
,aspa.create_awt_invoices_type "Create Withholding Invoice"
,aspa.withholding_date_basis "Withholding Date Basis"
,aspa.enable_1099_on_awt_flag "Incl IT Tax Type on WH Dists" --"Include Income Tax Type on Withholding Distributions"
-------Supplier Tab Details-----------------------------------------------------
,aspa.invoice_currency_code "Invoice Currency"
,aspa.vendor_pay_group_lookup_code "Pay Group2"
,aspa.terms_date_basis "Terms Date Basis"
,aspa.pay_date_basis_lookup_code "Pay Date Basis"
,att2.name "Payment Terms2" --Need to confirm
-------Reports Tab Details-----------------------------------------------------
,aspa.sort_by_alternate_field "Sort By Alternate Field"
FROM ap_system_parameters_all aspa
,hr_operating_units hou
,gl_code_combinations_kfv gcck
,gl_code_combinations_kfv gcck2
,gl_code_combinations_kfv gcck3
,gl_code_combinations_kfv gcck4
,ap_terms_tl att
,gl_code_combinations_kfv gcck5
,ap_tolerances at
,ap_tolerances at2
,gl_code_combinations_kfv gcck6
,gl_code_combinations_kfv gcck7
,ap_expense_reports aer
,ap_terms_tl att2
,ap_awt_groups aag
WHERE 1=1
AND hou.organization_id=nvl(:P_ORG_ID,hou.organization_id)
AND aspa.org_id=hou.organization_id
AND aspa.gain_code_combination_id=gcck.code_combination_id
AND aspa.loss_code_combination_id=gcck2.code_combination_id
AND aspa.rounding_error_ccid=gcck3.code_combination_id
AND aspa.freight_code_combination_id=gcck4.code_combination_id(+)
AND att.term_id=aspa.prepayment_terms_id
AND aspa.prepay_tax_diff_ccid=gcck5.code_combination_id(+)
AND aspa.tolerance_id=at.tolerance_id(+)
AND aspa.services_tolerance_id=at2.tolerance_id(+)
AND aspa.interest_code_combination_id=gcck6.code_combination_id(+)
AND aer.expense_report_id(+)=aspa.expense_report_id
AND aspa.interest_accts_pay_ccid=gcck7.code_combination_id(+)
AND att2.term_id(+)=aspa.terms_id
AND aag.group_id(+)=aspa.default_awt_group_id
;