ONT Transaction Types Listing

select  tv.transaction_type_id, 
tv.name Transaction_Type_Name,
tv.description,
tv.start_date_active,
tv.end_date_active,
tv.transaction_type_code,
tv.order_category_code,
ol1.meaning agreement_type,
olt1.name Default_Inbound_Line_Type,
olt2.name Default_Outbound_Line_Type,
tv.agreement_required_flag,
tv.po_required_flag,
opl.name Price_List,
tv.enforce_line_prices_flag,
ocr1.name Entry_Credit_Check_Rule,
ocr2.name Shipping_Credit_Check_Rule,
ood.organization_name warehouse,
orf.description Shipping_Method,
ol2.meaning Shipment_Priority,
oft.freight_terms,
al.meaning fob,
fl.meaning Shipment_Source_Type,
fc.meaning Demand_Class,
ol3.meaning Scheduling_Level,
tv.depot_repair_code,
rr1.name Invoicing_Rule,
rr2.name Accounting_Rule,
rbc1.name Invoicing_Source,
rbc2.name Non_Delivery_Invoice_Source,
tv.accounting_credit_method_code,
tv.invoicing_credit_method_code,
rct.name Receivables_Transaction_Type,
tv.cost_of_goods_sold_account,
fcv.name currency_code,
gl.user_conversion_type,
tv.auto_scheduling_flag,
null C_COGS_FLEXDATA, 
tv.inspection_required_flag, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('c_cogs_flexfield', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_COGS_FLEXFIELD
from oe_transaction_types_vl tv, 
oe_lookups ol1,
oe_line_types_v olt1, 
oe_line_types_v olt2, 
oe_price_lists_v opl,
oe_credit_check_rules ocr1,
oe_credit_check_rules ocr2,
org_organization_definitions ood,
org_freight orf,
oe_lookups ol2,
oe_frght_terms_active_v oft,
ar_lookups al,
fnd_lookup_values_vl fl,
fnd_common_lookups fc,
ra_rules rr1,
ra_rules rr2,
ra_batch_sources rbc1,
ra_batch_sources rbc2,
ra_cust_trx_types rct,
fnd_currencies_vl fcv,
gl_daily_conversion_types gl,
oe_lookups ol3,
GL_CODE_COMBINATIONS GCC   
where &lp_where_clause
ol1.lookup_type(+) = 'AGREEMENT_TYPE'
and ol1.lookup_code(+) = tv.agreement_type_code
and olt1.line_type_id(+) = tv.default_inbound_line_type_id
and olt2.line_type_id(+) = tv.default_outbound_line_type_id
and opl.price_list_id(+) = tv.price_list_id
and ocr1.credit_check_rule_id(+) = tv.entry_credit_check_rule_id
and ocr2.credit_check_rule_id(+) = tv.shipping_credit_check_rule_id
and ood.organization_id(+) = tv.warehouse_id
and orf.freight_code(+) = tv.shipping_method_code
and orf.organization_id(+) = tv.org_id
and ol2.lookup_type(+)= 'SHIPMENT_PRIORITY'
and ol2.lookup_code(+) = tv.shipment_priority_code
and ol3.lookup_type(+) = 'SCHEDULING_LEVEL'
and ol3.lookup_code(+) = tv.scheduling_level_code
and al.lookup_type(+) = 'FOB'
and al.lookup_code(+) = tv.fob_point_code
and oft.freight_terms_code(+) = tv.freight_terms_code
and fl.lookup_type(+) = 'SHIPMENT SOURCE TYPE'
and fl.lookup_code(+) = tv.ship_source_type_code
and fc.lookup_type(+) = 'DEMAND_CLASS'
and fc.lookup_code(+) = tv.demand_class_code
and rr1.rule_id(+) = tv.invoicing_rule_id
and rr2.rule_id(+) = tv.accounting_rule_id
and rbc1.batch_source_id(+) = tv.invoice_source_id
and rbc2.batch_source_id(+) = tv.non_delivery_invoice_source_id
and rct.cust_trx_type_id(+) =  tv.cust_trx_type_id
and fcv.currency_code(+) = tv.currency_code
and gl.conversion_type(+) = tv.conversion_type_code
and tv.cost_of_goods_sold_account = GCC.CODE_COMBINATION_ID(+)

select tv.transaction_type_id, tv.name Transaction_Type_Name, tv.description, tv.start_date_active, tv.end_date_active, tv.transaction_type_code, tv.order_category_code, ol1.meaning agreement_type, olt1.name Default_Inbound_Line_Type, olt2.name Default_Outbound_Line_Type, tv.agreement_required_flag, tv.po_required_flag, opl.name Price_List, tv.enforce_line_prices_flag, ocr1.name Entry_Credit_Check_Rule, ocr2.name Shipping_Credit_Check_Rule, ood.organization_name warehouse, orf.description Shipping_Method, ol2.meaning Shipment_Priority, oft.freight_terms, al.meaning fob, fl.meaning Shipment_Source_Type, fc.meaning Demand_Class, ol3.meaning Scheduling_Level, tv.depot_repair_code, rr1.name Invoicing_Rule, rr2.name Accounting_Rule, rbc1.name Invoicing_Source, rbc2.name Non_Delivery_Invoice_Source, tv.accounting_credit_method_code, tv.invoicing_credit_method_code, rct.name Receivables_Transaction_Type, tv.cost_of_goods_sold_account, fcv.name currency_code, gl.user_conversion_type, tv.auto_scheduling_flag, null C_COGS_FLEXDATA, tv.inspection_required_flag, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_cogs_flexfield', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_COGS_FLEXFIELD from oe_transaction_types_vl tv, oe_lookups ol1, oe_line_types_v olt1, oe_line_types_v olt2, oe_price_lists_v opl, oe_credit_check_rules ocr1, oe_credit_check_rules ocr2, org_organization_definitions ood, org_freight orf, oe_lookups ol2, oe_frght_terms_active_v oft, ar_lookups al, fnd_lookup_values_vl fl, fnd_common_lookups fc, ra_rules rr1, ra_rules rr2, ra_batch_sources rbc1, ra_batch_sources rbc2, ra_cust_trx_types rct, fnd_currencies_vl fcv, gl_daily_conversion_types gl, oe_lookups ol3, GL_CODE_COMBINATIONS GCC where &lp_where_clause ol1.lookup_type(+) = 'AGREEMENT_TYPE' and ol1.lookup_code(+) = tv.agreement_type_code and olt1.line_type_id(+) = tv.default_inbound_line_type_id and olt2.line_type_id(+) = tv.default_outbound_line_type_id and opl.price_list_id(+) = tv.price_list_id and ocr1.credit_check_rule_id(+) = tv.entry_credit_check_rule_id and ocr2.credit_check_rule_id(+) = tv.shipping_credit_check_rule_id and ood.organization_id(+) = tv.warehouse_id and orf.freight_code(+) = tv.shipping_method_code and orf.organization_id(+) = tv.org_id and ol2.lookup_type(+)= 'SHIPMENT_PRIORITY' and ol2.lookup_code(+) = tv.shipment_priority_code and ol3.lookup_type(+) = 'SCHEDULING_LEVEL' and ol3.lookup_code(+) = tv.scheduling_level_code and al.lookup_type(+) = 'FOB' and al.lookup_code(+) = tv.fob_point_code and oft.freight_terms_code(+) = tv.freight_terms_code and fl.lookup_type(+) = 'SHIPMENT SOURCE TYPE' and fl.lookup_code(+) = tv.ship_source_type_code and fc.lookup_type(+) = 'DEMAND_CLASS' and fc.lookup_code(+) = tv.demand_class_code and rr1.rule_id(+) = tv.invoicing_rule_id and rr2.rule_id(+) = tv.accounting_rule_id and rbc1.batch_source_id(+) = tv.invoice_source_id and rbc2.batch_source_id(+) = tv.non_delivery_invoice_source_id and rct.cust_trx_type_id(+) = tv.cust_trx_type_id and fcv.currency_code(+) = tv.currency_code and gl.conversion_type(+) = tv.conversion_type_code and tv.cost_of_goods_sold_account = GCC.CODE_COMBINATION_ID(+)