Oracle EBS GST-AP Financial Options

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

Tables:-
FINANCIALS_SYSTEM_PARAMS_ALL
HR_OPERATING_UNITS
GL_LEDGER_CONFIG_DETAILS
HRFV_BUSINESS_GROUPS
XLE_ENTITY_PROFILES
ORG_ORGANIZATION_DEFINITIONS
PO_LOCATIONS_VAL_V

SQL Example:-

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
APPS.FINANCIALS_SYSTEM_PARAMS_ALL fsp ,
APPS.HR_OPERATING_UNITS HOU,
APPS.GL_LEDGER_CONFIG_DETAILS GLCV,
APPS.HRFV_BUSINESS_GROUPS HBG,
APPS.XLE_ENTITY_PROFILES XEP,
APPS.ORG_ORGANIZATION_DEFINITIONS OOD ,
APPS.PO_LOCATIONS_VAL_V PLVV ,
APPS.PO_LOCATIONS_VAL_V PLVV2,
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.GL_CODE_COMBINATIONS_KFV GCCK5 ,
APPS.GL_CODE_COMBINATIONS_KFV GCCK6 ,
APPS.GL_CODE_COMBINATIONS_KFV GCCK7 ,
APPS.GL_CODE_COMBINATIONS_KFV GCCK8 ,
APPS.GL_CODE_COMBINATIONS_KFV GCCK9
WHERE 1=1
AND xep.legal_entity_id=glcv.object_id
AND glcv.object_id = hou.default_legal_context_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 ood.organization_id               =fsp.inventory_organization_id
AND fsp.org_id                        =hou.organization_id
AND plvv.location_id(+)               =fsp.ship_to_location_id
AND plvv2.location_id(+)              =fsp.ship_to_location_id 
AND hou.name= '&&';