Oracle EBS GST-OFI Transaction Source

Oracle EBS GST-OFI Transaction Source:-
Configuration:OFI Transaction Source,
Responsibility:Receivables Manager,
Navigation:Setup->Transactions ->Sources
Tables:-
RA_BATCH_SOURCES_ALL
HR_OPERATING_UNITS
RA_GROUPING_RULES
XLE_ENTITY_PROFILES
ra_cust_trx_types_all
ra_batch_sources_all

Example:-

SELECT DISTINCT
hou.NAME "Operating Unit"
,xep.name "LEGAL ENTITY"
,rbsa.name "Name"
,DECODE (rbsa.batch_source_type, 'INV', 'Manual', 'Imported') "Type"
,rbsa.description "Description"
,DECODE (rbsa.status, 'A', 'Yes', 'No') "Active"
,TO_CHAR (rbsa.start_date,'DD-MON-YYYY') "Start Date"
,TO_CHAR(rbsa.end_date,'DD-MON-YYYY') "End Date"
,rbsa.auto_batch_numbering_flag "Automatic Bactch Numbering"
,rbsa.last_batch_num "Last Number 1"
,DECODE (rbsa.auto_trx_numbering_flag, 'Y', 'Yes', 'No') "Automatic Transaction Num"
,rbsa.last_batch_num "Last Number 2"
,rbsa.copy_doc_number_flag
,rbsa.allow_duplicate_trx_num_flag
,rbsa.copy_inv_tidff_to_cm_flag
,rbsa.gen_line_level_bal_flag
,rbsa.receipt_handling_option
,DECODE(rbsa.default_reference, '1','interface_header_attribute1', '4', 'interface_header_attribute4', '8', 'interface_header_attribute8') "Reference Field Default Value"
,rctty.name "Standard Transaction Type"
,rbsa1.name "Credit Memo Batch Source"
,rbsa.invalid_lines_rule "Invalid Lines"
,rbsa.gl_date_period_rule "GL Date Period"
,rgr.name "GROUPING RULE"
,DECODE (rbsa.create_clearing_flag, 'Y', 'Checked', 'Unchecked') "Create Clearing"
,DECODE (rbsa.sales_credit_type_rule, 'Y', 'Checked', 'Unchecked') "Allow Sales Credit"
,rbsa.sold_customer_rule "Sold To Customer",rbsa.bill_customer_rule "Bill To Customer"
,rbsa.bill_address_rule "Bill To Address"
,rbsa.bill_contact_rule "Bill To Contact"
,rbsa.ship_customer_rule "Ship To Customer"
,rbsa.ship_address_rule "Ship To Address"
,rbsa.ship_contact_rule "Ship To Contact"
,rbsa.receipt_method_rule "Payment Method Rule"
,rbsa.customer_bank_account_rule "Customer Bank Account"
,rbsa.invoicing_rule_rule "Accounting Invoice Rule"
,rbsa.accounting_rule_rule "Accounting Rule"
,rbsa.accounting_flexfield_rule "Accounting Flex field"
,DECODE (rbsa.derive_date_flag, 'Y', 'Checked', 'Unchecked') "Derive Date"
,rbsa.term_rule "Payment Rule"
,rbsa.rev_acc_allocation_rule
,rbsa.cust_trx_type_rule
,rbsa.memo_reason_rule
,rbsa.sales_territory_rule
,rbsa.inventory_item_rule
,rbsa.unit_of_measure_rule
,rbsa.ship_via_rule
,rbsa.related_document_rule
,rbsa.salesperson_rule
,rbsa.sales_credit_type_rule
,rbsa.sales_credit_rule
FROM APPS.RA_BATCH_SOURCES_ALL RBSA,
APPS.HR_OPERATING_UNITS hou,
APPS.RA_GROUPING_RULES rgr,
APPS.XLE_ENTITY_PROFILES xep,
APPS.ra_cust_trx_types_all rctty,
APPS.ra_batch_sources_all rbsa1
WHERE 1=1
AND rbsa.org_id = hou.organization_id 
AND rbsa.LEGAL_ENTITY_ID=xep.LEGAL_ENTITY_ID(+) 
AND RBSA.GROUPING_RULE_ID=rgr.GROUPING_RULE_ID(+) 
AND rbsa.credit_memo_batch_source_id = rbsa1.batch_source_id (+) 
AND rbsa.default_inv_trx_type =rctty.cust_trx_type_id (+)
AND  rbsa.org_id = rctty.org_id (+) 
AND (rbsa.name LIKE '%OFI%' )
AND rbsa.CREATED_BY NOT IN ('-1','0','1','3','4','5','6','7') 
AND rbsa.end_date IS NULL
AND hou.name= '&&';