ONT Transaction Types Listing

Description
Categories: BI Publisher, Sales
Application: Order Management
Source: Transaction Types Listing Report (XML)
Short Name: OEXORDTP_XML
DB package: ONT_OEXORDTP_XMLP_PKG
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(+)
Parameter Name SQL text Validation
Ledger Id
 
Number
Order Category Code
 
LOV Oracle
Transaction Type Code
 
LOV Oracle
Transaction Type (To)
 
LOV Oracle
Transaction Type (From)
 
LOV Oracle