Oracle EBS GST-AP Payables Options

Oracle EBS GST-AP Payables Options
Configuration:AP-Payables Options,
Responsibility:Oracle Payables,
Navigation:Setup ->Options ->Payables Options

Tables:-
AP_SYSTEM_PARAMETERS_ALL
gl_daily_conversion_types 
HR_OPERATING_UNITS
GL_CODE_COMBINATIONS_KFV
AP_TERMS_TL 
AP_TOLERANCES 
AP_EXPENSE_REPORTS
AP_AWT_GROUPS

Example:-

SELECT DISTINCT
hou.name
,aspa.when_to_account_pmt
,aspa.recon_accounting_flag
,aspa.when_to_account_gain_loss
,aspa.recon_accounting_flag
,aspa.future_dated_pmt_acct_source
,aspa.liability_post_lookup_code
,aspa.discount_distribution_method
,aspa.prorate_int_inv_across_dists
,aspa.build_prepayment_accounts_flag
,aspa.multi_currency_flag
,aspa.make_rate_mandatory_flag
,aspa.calc_user_xrate
,gdc.USER_CONVERSION_TYPE
,gcck.concatenated_segments
,gcck2.concatenated_segments
,gcck3.concatenated_segments
,aspa.combined_filing_flag
,aspa.income_tax_region_flag
,aspa.income_tax_region
,aspa.confirm_date_as_inv_num_flag
,aspa.approvals_option
,aspa.inv_doc_category_override
,aspa.allow_paid_invoice_adjust
,aspa.recalc_pay_schedule_flag
,aspa.allow_supplier_bank_override
,aspa.allow_inv_third_party_ovrd
,aspa.receipt_acceptance_days
,aspa.gl_date_from_receipt_flag
,gcck4.concatenated_segments
,att.name
,aspa.add_days_settlement_date
,gcck5.concatenated_segments
,aspa.approval_workflow_flag
,aspa.allow_force_approval_flag
,aspa.validate_before_approval_flag
,aspa.approval_timing
,aspa.allow_final_match_flag
,aspa.allow_dist_match_flag
,aspa.allow_flex_override_flag
,aspa.transfer_desc_flex_flag
,at.tolerance_name
,at2.tolerance_name
,aspa.auto_calculate_interest_flag
,aspa.interest_tolerance_amount
,gcck6.concatenated_segments
,gcck7.concatenated_segments
,aer.report_type
,aspa.apply_advances_default
,aspa.create_employee_vendor_flag
,att2.name
,aspa.employee_pay_group_lookup_code
,aspa.employee_payment_priority
,aspa.hold_unmatched_invoices_flag
,aspa.disc_is_inv_less_tax_flag
,aspa.post_dated_payments_flag
,aspa.replace_check_flag
,aspa.update_pay_site_flag
,aspa.use_bank_charge_flag
,aspa.bank_charge_bearer
,aspa.allow_pymt_third_party_ovrd
,aspa.pay_doc_category_override
,aspa.allow_awt_flag
,aspa.allow_awt_override
,aag.name
,aspa.awt_include_discount_amt
,aspa.awt_include_tax_amt
,aspa.create_awt_dists_type
,aspa.create_awt_invoices_type
,aspa.withholding_date_basis
,aspa.enable_1099_on_awt_flag
,aspa.invoice_currency_code
,aspa.vendor_pay_group_lookup_code
,aspa.terms_date_basis
,aspa.pay_date_basis_lookup_code
,att2.name,aspa.sort_by_alternate_field
 FROM
 APPS.AP_SYSTEM_PARAMETERS_ALL ASPA 
,APPS.gl_daily_conversion_types gdc 
,APPS.HR_OPERATING_UNITS HOU 
,APPS.GL_CODE_COMBINATIONS_KFV GCCK 
,APPS.GL_CODE_COMBINATIONS_KFV GCCK2 
,APPS.GL_CODE_COMBINATIONS_KFV GCCK3 
,APPS.GL_CODE_COMBINATIONS_KFV GCCK4 
,APPS.AP_TERMS_TL ATT 
,APPS.GL_CODE_COMBINATIONS_KFV GCCK5 
,APPS.AP_TOLERANCES AT 
,APPS.AP_TOLERANCES AT2 
,APPS.GL_CODE_COMBINATIONS_KFV GCCK6 
,APPS.GL_CODE_COMBINATIONS_KFV GCCK7 
,APPS.AP_EXPENSE_REPORTS AER 
,APPS.AP_TERMS_TL ATT2 
,APPS.AP_AWT_GROUPS AAG 
WHERE 1=1
AND aspa.org_id=hou.organization_id 
AND aspa.default_exchange_rate_type=gdc.CONVERSION_TYPE(+) 
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 
AND hou.name= '&&';