ONT Transaction Types Listing
Description
Categories: BI Publisher
Columns: Transaction Type Id, Transaction Type Name, Description, Start Date Active, End Date Active, Transaction Type Code, Order Category Code, Org Id, Agreement Type, Default Inbound Line Type ...
Columns: Transaction Type Id, Transaction Type Name, Description, Start Date Active, End Date Active, Transaction Type Code, Order Category Code, Org Id, Agreement Type, Default Inbound Line Type ...
Application: Order Management
Source: Transaction Types Listing Report (XML)
Short Name: OEXORDTP_XML
DB package: ONT_OEXORDTP_XMLP_PKG
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, tv.org_id, 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 1=1 and 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 | |
---|---|---|---|
Operating Unit |
|
LOV | |
Transaction Type (From) |
|
LOV Oracle | |
Transaction Type (To) |
|
LOV Oracle | |
Transaction Type Code |
|
LOV Oracle | |
Order Category Code |
|
LOV Oracle |