View: OE_TRANSACTION_TYPES_V

Product:	ONT - Order Management
Description:
Implementation/DBA Data:	APPS.OE_TRANSACTION_TYPES_V

View Text

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'

Columns