VIEW: APPS.OE_TRANSACTION_TYPES_V

Source

View Text - Preformatted

SELECT vl.ROWID ROW_ID, vl.TRANSACTION_TYPE_ID, vl.TRANSACTION_TYPE_CODE, vl.ORDER_CATEGORY_CODE, vl.START_DATE_ACTIVE, vl.END_DATE_ACTIVE, vl.CREATION_DATE, vl.CREATED_BY, vl.LAST_UPDATE_DATE, vl.LAST_UPDATED_BY, vl.LAST_UPDATE_LOGIN, vl.PROGRAM_APPLICATION_ID, vl.PROGRAM_ID, vl.REQUEST_ID, vl.CURRENCY_CODE, vl.CONVERSION_TYPE_CODE, vl.CUST_TRX_TYPE_ID, vl.COST_OF_GOODS_SOLD_ACCOUNT, vl.ENTRY_CREDIT_CHECK_RULE_ID, vl.SHIPPING_CREDIT_CHECK_RULE_ID, vl.PRICE_LIST_ID, vl.ENFORCE_LINE_PRICES_FLAG, vl.MIN_MARGIN_PERCENT, vl.WAREHOUSE_ID, vl.DEMAND_CLASS_CODE, vl.SHIPMENT_PRIORITY_CODE, vl.SHIPPING_METHOD_CODE, vl.FREIGHT_TERMS_CODE, vl.FOB_POINT_CODE, vl.SHIP_SOURCE_TYPE_CODE, vl.AGREEMENT_TYPE_CODE, vl.AGREEMENT_REQUIRED_FLAG, vl.PO_REQUIRED_FLAG, vl.INVOICING_RULE_ID, vl.INVOICING_CREDIT_METHOD_CODE, vl.ACCOUNTING_RULE_ID, vl.ACCOUNTING_CREDIT_METHOD_CODE, vl.INVOICE_SOURCE_ID, vl.NON_DELIVERY_INVOICE_SOURCE_ID, vl.DEFAULT_INBOUND_LINE_TYPE_ID, vl.DEFAULT_OUTBOUND_LINE_TYPE_ID, vl.INSPECTION_REQUIRED_FLAG, vl.DEPOT_REPAIR_CODE, vl.AUTO_SCHEDULING_FLAG, vl.SCHEDULING_LEVEL_CODE, vl.DEFAULT_FULFILLMENT_SET, vl.DEFAULT_LINE_SET_CODE, vl.CONTEXT, vl.ATTRIBUTE1, vl.ATTRIBUTE2, vl.ATTRIBUTE3, vl.ATTRIBUTE4, vl.ATTRIBUTE5, vl.ATTRIBUTE6, vl.ATTRIBUTE7, vl.ATTRIBUTE8, vl.ATTRIBUTE9, vl.ATTRIBUTE10, vl.ATTRIBUTE11, vl.ATTRIBUTE12, vl.ATTRIBUTE13, vl.ATTRIBUTE14, vl.ATTRIBUTE15, vl.NAME, vl.DESCRIPTION, vl.ORG_ID, hou.NAME, vl.TAX_CALCULATION_EVENT_CODE, vl.PICKING_CREDIT_CHECK_RULE_ID, vl.PACKING_CREDIT_CHECK_RULE_ID, vl.SALES_DOCUMENT_TYPE_CODE, oel.meaning SALES_DOCUMENT_TYPE, vl.def_transaction_phase_code, vl.quote_num_as_ord_num_flag, vl.layout_template_id, vl.contract_template_id, vl.CREDIT_CARD_REV_REAUTH_CODE, vl.USE_AME_APPROVAL from OE_TRANSACTION_TYPES_VL vl, HR_ORGANIZATION_UNITS hou, oe_lookups oel WHERE vl.org_id = hou.organization_id(+) and oel.lookup_code (+) = vl.sales_document_type_code and oel.lookup_type (+) = 'SALES_DOCUMENT_TYPE'

View Text - HTML Formatted

SELECT VL.ROWID ROW_ID
, VL.TRANSACTION_TYPE_ID
, VL.TRANSACTION_TYPE_CODE
, VL.ORDER_CATEGORY_CODE
, VL.START_DATE_ACTIVE
, VL.END_DATE_ACTIVE
, VL.CREATION_DATE
, VL.CREATED_BY
, VL.LAST_UPDATE_DATE
, VL.LAST_UPDATED_BY
, VL.LAST_UPDATE_LOGIN
, VL.PROGRAM_APPLICATION_ID
, VL.PROGRAM_ID
, VL.REQUEST_ID
, VL.CURRENCY_CODE
, VL.CONVERSION_TYPE_CODE
, VL.CUST_TRX_TYPE_ID
, VL.COST_OF_GOODS_SOLD_ACCOUNT
, VL.ENTRY_CREDIT_CHECK_RULE_ID
, VL.SHIPPING_CREDIT_CHECK_RULE_ID
, VL.PRICE_LIST_ID
, VL.ENFORCE_LINE_PRICES_FLAG
, VL.MIN_MARGIN_PERCENT
, VL.WAREHOUSE_ID
, VL.DEMAND_CLASS_CODE
, VL.SHIPMENT_PRIORITY_CODE
, VL.SHIPPING_METHOD_CODE
, VL.FREIGHT_TERMS_CODE
, VL.FOB_POINT_CODE
, VL.SHIP_SOURCE_TYPE_CODE
, VL.AGREEMENT_TYPE_CODE
, VL.AGREEMENT_REQUIRED_FLAG
, VL.PO_REQUIRED_FLAG
, VL.INVOICING_RULE_ID
, VL.INVOICING_CREDIT_METHOD_CODE
, VL.ACCOUNTING_RULE_ID
, VL.ACCOUNTING_CREDIT_METHOD_CODE
, VL.INVOICE_SOURCE_ID
, VL.NON_DELIVERY_INVOICE_SOURCE_ID
, VL.DEFAULT_INBOUND_LINE_TYPE_ID
, VL.DEFAULT_OUTBOUND_LINE_TYPE_ID
, VL.INSPECTION_REQUIRED_FLAG
, VL.DEPOT_REPAIR_CODE
, VL.AUTO_SCHEDULING_FLAG
, VL.SCHEDULING_LEVEL_CODE
, VL.DEFAULT_FULFILLMENT_SET
, VL.DEFAULT_LINE_SET_CODE
, VL.CONTEXT
, VL.ATTRIBUTE1
, VL.ATTRIBUTE2
, VL.ATTRIBUTE3
, VL.ATTRIBUTE4
, VL.ATTRIBUTE5
, VL.ATTRIBUTE6
, VL.ATTRIBUTE7
, VL.ATTRIBUTE8
, VL.ATTRIBUTE9
, VL.ATTRIBUTE10
, VL.ATTRIBUTE11
, VL.ATTRIBUTE12
, VL.ATTRIBUTE13
, VL.ATTRIBUTE14
, VL.ATTRIBUTE15
, VL.NAME
, VL.DESCRIPTION
, VL.ORG_ID
, HOU.NAME
, VL.TAX_CALCULATION_EVENT_CODE
, VL.PICKING_CREDIT_CHECK_RULE_ID
, VL.PACKING_CREDIT_CHECK_RULE_ID
, VL.SALES_DOCUMENT_TYPE_CODE
, OEL.MEANING SALES_DOCUMENT_TYPE
, VL.DEF_TRANSACTION_PHASE_CODE
, VL.QUOTE_NUM_AS_ORD_NUM_FLAG
, VL.LAYOUT_TEMPLATE_ID
, VL.CONTRACT_TEMPLATE_ID
, VL.CREDIT_CARD_REV_REAUTH_CODE
, VL.USE_AME_APPROVAL
FROM OE_TRANSACTION_TYPES_VL VL
, HR_ORGANIZATION_UNITS HOU
, OE_LOOKUPS OEL
WHERE VL.ORG_ID = HOU.ORGANIZATION_ID(+)
AND OEL.LOOKUP_CODE (+) = VL.SALES_DOCUMENT_TYPE_CODE
AND OEL.LOOKUP_TYPE (+) = 'SALES_DOCUMENT_TYPE'