select
hou.name operating_unit,
rtt.name transaction_name,
rtt.description transaction_description,
xxen_util.meaning(rtt.type,'INV/CM',222) transaction_class,
xxen_util.meaning(rtt.accounting_affect_flag,'YES_NO',0) open_receivable,
xxen_util.meaning(rtt.post_to_gl,'YES_NO',0) post_to_gl,
xxen_util.meaning(rtt.default_printing_option,'INVOICE_PRINT_OPTIONS',222) printing_option,
xxen_util.meaning(rtt.default_status,'INVOICE_TRX_STATUS',222) transaction_status,
xxen_util.meaning(rtt.allow_freight_flag,'YES_NO',0) allow_freight,
xxen_util.meaning(rtt.tax_calculation_flag,'YES_NO',0) tax_calculation,
xxen_util.meaning(rtt.creation_sign,'SIGN',222) creation_sign,
xxen_util.meaning(rtt.natural_application_only_flag,'YES_NO',0) natural_application_only,
xxen_util.meaning(rtt.allow_overapplication_flag,'YES_NO',0) allow_overapplication,
rtt.start_date start_date,
rtt.end_date end_date,
(select rctt.name
from ra_cust_trx_types rctt
where rctt.cust_trx_type_id = rtt.subsequent_trx_type_id and
rctt.org_id = rtt.org_id
) invoice_type,
(select rctt.name
from ra_cust_trx_types rctt
where rctt.cust_trx_type_id = rtt.credit_memo_type_id and
rctt.org_id = rtt.org_id
) credit_memo_type,
(select rt.name
from ra_terms rt
where rt.term_id = rtt.default_term
) term_name,
gl7.concatenated_segments tax_account,
gl1.concatenated_segments revenue_account,
gl2.concatenated_segments freight_account,
gl3.concatenated_segments receivable_account,
gl4.concatenated_segments clearing_account,
gl5.concatenated_segments unbilled_account,
gl6.concatenated_segments unearned_account
from
hr_operating_units hou,
ra_cust_trx_types rtt,
gl_code_combinations_kfv gl1,
gl_code_combinations_kfv gl2,
gl_code_combinations_kfv gl3,
gl_code_combinations_kfv gl4,
gl_code_combinations_kfv gl5,
gl_code_combinations_kfv gl6,
gl_code_combinations_kfv gl7
where
1=1 and
hou.organization_id = rtt.org_id and
gl1.code_combination_id(+) = rtt.gl_id_rev and
gl2.code_combination_id(+) = rtt.gl_id_freight and
gl3.code_combination_id(+) = rtt.gl_id_rec and
gl4.code_combination_id(+) = rtt.gl_id_clearing and
gl5.code_combination_id(+) = rtt.gl_id_unbilled and
gl6.code_combination_id(+) = rtt.gl_id_unearned and
gl7.code_combination_id(+) = rtt.gl_id_tax
order by
hou.name,
rtt.name |
