VIEW: APPS.OE_PC_VTMPLT_COLS_DFV

Source

View Text - Preformatted

SELECT ROWID, COLUMN_NAME, (DECODE (COLUMN_NAME, 'AGREEMENT_ID', VALUE_STRING, NULL)), (DECODE (COLUMN_NAME, 'ATO_LINE_ID', FND_NUMBER.CANONICAL_TO_NUMBER(VALUE_STRING), NULL)), (DECODE (COLUMN_NAME, 'AUTOMATIC_FLAG', VALUE_STRING, NULL)), (DECODE (COLUMN_NAME, 'BLANKET_LINE_MAX_AMOUNT', FND_NUMBER.CANONICAL_TO_NUMBER(VALUE_STRING), NULL)), (DECODE (COLUMN_NAME, 'BLANKET_LINE_MIN_AMOUNT', FND_NUMBER.CANONICAL_TO_NUMBER(VALUE_STRING), NULL)), (DECODE (COLUMN_NAME, 'BLANKET_MAX_AMOUNT', FND_NUMBER.CANONICAL_TO_NUMBER(VALUE_STRING), NULL)), (DECODE (COLUMN_NAME, 'BLANKET_MAX_QUANTITY', FND_NUMBER.CANONICAL_TO_NUMBER(VALUE_STRING), NULL)), (DECODE (COLUMN_NAME, 'BLANKET_MIN_AMOUNT', FND_NUMBER.CANONICAL_TO_NUMBER(VALUE_STRING), NULL)), (DECODE (COLUMN_NAME, 'BLANKET_MIN_QUANTITY', FND_NUMBER.CANONICAL_TO_NUMBER(VALUE_STRING), NULL)), (DECODE (COLUMN_NAME, 'BOOKED_FLAG', VALUE_STRING, NULL)), (DECODE (COLUMN_NAME, 'CANCELLED_FLAG', VALUE_STRING, NULL)), (DECODE (COLUMN_NAME, 'CONVERSION_TYPE_CODE', VALUE_STRING, NULL)), (DECODE (COLUMN_NAME, 'CREATED_BY', VALUE_STRING, NULL)), (DECODE (COLUMN_NAME, 'CUSTOMER_SIGNATURE', VALUE_STRING, NULL)), (DECODE (COLUMN_NAME, 'CUSTOMER_SIGNATURE_DATE', TO_DATE(VALUE_STRING, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (COLUMN_NAME, 'DB_FLAG', VALUE_STRING, NULL)), (DECODE (COLUMN_NAME, 'DELIVER_TO_ORG_ID', VALUE_STRING, NULL)), (DECODE (COLUMN_NAME, 'DEMAND_CLASS_CODE', VALUE_STRING, NULL)), (DECODE (COLUMN_NAME, 'DRAFT_SUBMITTED_FLAG', VALUE_STRING, NULL)), (DECODE (COLUMN_NAME, 'FLOW_STATUS_CODE', VALUE_STRING, NULL)), (DECODE (COLUMN_NAME, 'FOB_POINT_CODE', VALUE_STRING, NULL)), (DECODE (COLUMN_NAME, 'FREIGHT_CARRIER_CODE', VALUE_STRING, NULL)), (DECODE (COLUMN_NAME, 'FULFILLED_FLAG', VALUE_STRING, NULL)), (DECODE (COLUMN_NAME, 'INVOICED_FLAG', VALUE_STRING, NULL)), (DECODE (COLUMN_NAME, 'INVOICE_INTERFACE_STATUS_CODE', VALUE_STRING, NULL)), (DECODE (COLUMN_NAME, 'ITEM_REVISION', FND_NUMBER.CANONICAL_TO_NUMBER(VALUE_STRING), NULL)), (DECODE (COLUMN_NAME, 'ITEM_TYPE_CODE', VALUE_STRING, NULL)), (DECODE (COLUMN_NAME, 'LINE_CATEGORY_CODE', VALUE_STRING, NULL)), (DECODE (COLUMN_NAME, 'LINE_TYPE_ID', VALUE_STRING, NULL)), (DECODE (COLUMN_NAME, 'LIST_LINE_TYPE_CODE', VALUE_STRING, NULL)), (DECODE (COLUMN_NAME, 'MAX_RELEASE_AMOUNT', FND_NUMBER.CANONICAL_TO_NUMBER(VALUE_STRING), NULL)), (DECODE (COLUMN_NAME, 'MAX_RELEASE_QUANTITY', FND_NUMBER.CANONICAL_TO_NUMBER(VALUE_STRING), NULL)), (DECODE (COLUMN_NAME, 'MIN_RELEASE_AMOUNT', FND_NUMBER.CANONICAL_TO_NUMBER(VALUE_STRING), NULL)), (DECODE (COLUMN_NAME, 'MIN_RELEASE_QUANTITY', FND_NUMBER.CANONICAL_TO_NUMBER(VALUE_STRING), NULL)), (DECODE (COLUMN_NAME, 'ON_HOLD_FLAG', VALUE_STRING, NULL)), (DECODE (COLUMN_NAME, 'OPEN_FLAG', VALUE_STRING, NULL)), (DECODE (COLUMN_NAME, 'ORDERED_DATE', TO_DATE(VALUE_STRING, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (COLUMN_NAME, 'ORDERED_QUANTITY_UOM2', VALUE_STRING, NULL)), (DECODE (COLUMN_NAME, 'ORDER_CATEGORY_CODE', VALUE_STRING, NULL)), (DECODE (COLUMN_NAME, 'UOM_CODE', VALUE_STRING, 'ORDER_QUANTITY_UOM', VALUE_STRING, NULL)), (DECODE (COLUMN_NAME, 'ORDER_SOURCE_ID', VALUE_STRING, NULL)), (DECODE (COLUMN_NAME, 'ORDER_TYPE_ID', VALUE_STRING, NULL)), (DECODE (COLUMN_NAME, 'ORG_ID', VALUE_STRING, NULL)), (DECODE (COLUMN_NAME, 'OVERRIDE_AMOUNT_FLAG', VALUE_STRING, NULL)), (DECODE (COLUMN_NAME, 'OVERRIDE_BLANKET_CONTROLS_FLAG', VALUE_STRING, NULL)), (DECODE (COLUMN_NAME, 'OVERRIDE_RELEASE_CONTROLS_FLAG', VALUE_STRING, NULL)), (DECODE (COLUMN_NAME, 'PAYMENT_AMOUNT', FND_NUMBER.CANONICAL_TO_NUMBER(VALUE_STRING), NULL)), (DECODE (COLUMN_NAME, 'PAYMENT_COLLECTION_EVENT', VALUE_STRING, NULL)), (DECODE (COLUMN_NAME, 'PAYMENT_SET_ID', FND_NUMBER.CANONICAL_TO_NUMBER(VALUE_STRING), NULL)), (DECODE (COLUMN_NAME, 'PAYMENT_TERM_ID', VALUE_STRING, NULL)), (DECODE (COLUMN_NAME, 'PERCENT', FND_NUMBER.CANONICAL_TO_NUMBER(VALUE_STRING), NULL)), (DECODE (COLUMN_NAME, 'PRICE_LIST_ID', VALUE_STRING, NULL)), (DECODE (COLUMN_NAME, 'PRICING_DATE', TO_DATE(VALUE_STRING, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (COLUMN_NAME, 'PRICING_QUANTITY', FND_NUMBER.CANONICAL_TO_NUMBER(VALUE_STRING), NULL)), (DECODE (COLUMN_NAME, 'PROMISE_DATE', TO_DATE(VALUE_STRING, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (COLUMN_NAME, 'REQUEST_DATE', TO_DATE(VALUE_STRING, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (COLUMN_NAME, 'SALESREP_ID', VALUE_STRING, NULL)), (DECODE (COLUMN_NAME, 'SALES_CREDIT_TYPE_ID', VALUE_STRING, NULL)), (DECODE (COLUMN_NAME, 'SCHEDULE_ARRIVAL_DATE', TO_DATE(VALUE_STRING, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (COLUMN_NAME, 'SCHEDULE_SHIP_DATE', TO_DATE(VALUE_STRING, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (COLUMN_NAME, 'SHIPPED_QUANTITY', FND_NUMBER.CANONICAL_TO_NUMBER(VALUE_STRING), NULL)), (DECODE (COLUMN_NAME, 'SHIPPING_METHOD_CODE', VALUE_STRING, NULL)), (DECODE (COLUMN_NAME, 'SHIP_FROM_ORG_ID', VALUE_STRING, NULL)), (DECODE (COLUMN_NAME, 'SHIP_MODEL_COMPLETE_FLAG', VALUE_STRING, NULL)), (DECODE (COLUMN_NAME, 'SHIP_TO_ORG_ID', VALUE_STRING, NULL)), (DECODE (COLUMN_NAME, 'SOLD_TO_ORG_ID', VALUE_STRING, NULL)), (DECODE (COLUMN_NAME, 'SOURCE_DOCUMENT_TYPE_ID', VALUE_STRING, NULL)), (DECODE (COLUMN_NAME, 'SOURCE_TYPE_CODE', VALUE_STRING, NULL)), (DECODE (COLUMN_NAME, 'SUPPLIER_SIGNATURE', VALUE_STRING, NULL)), (DECODE (COLUMN_NAME, 'SUPPLIER_SIGNATURE_DATE', TO_DATE(VALUE_STRING, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (COLUMN_NAME, 'TOP_MODEL_LINE_ID', FND_NUMBER.CANONICAL_TO_NUMBER(VALUE_STRING), NULL)), (DECODE (COLUMN_NAME, 'TRANSACTIONAL_CURR_CODE', VALUE_STRING, NULL)), (DECODE (COLUMN_NAME, 'UPGRADED_FLAG', VALUE_STRING, NULL)), (DECODE (COLUMN_NAME, 'USER_STATUS_CODE', VALUE_STRING, NULL)), (DECODE (COLUMN_NAME, 'salesrep_id', VALUE_STRING, NULL)),  
 (DECODE (COLUMN_NAME,  
      'AGREEMENT_ID', COLUMN_NAME || '.' || VALUE_STRING,  
      'ATO_LINE_ID', COLUMN_NAME || '.' || VALUE_STRING,  
      'AUTOMATIC_FLAG', COLUMN_NAME || '.' || VALUE_STRING,  
      'BLANKET_LINE_MAX_AMOUNT', COLUMN_NAME || '.' || VALUE_STRING,  
      'BLANKET_LINE_MIN_AMOUNT', COLUMN_NAME || '.' || VALUE_STRING,  
      'BLANKET_MAX_AMOUNT', COLUMN_NAME || '.' || VALUE_STRING,  
      'BLANKET_MAX_QUANTITY', COLUMN_NAME || '.' || VALUE_STRING,  
      'BLANKET_MIN_AMOUNT', COLUMN_NAME || '.' || VALUE_STRING,  
      'BLANKET_MIN_QUANTITY', COLUMN_NAME || '.' || VALUE_STRING,  
      'BOOKED_FLAG', COLUMN_NAME || '.' || VALUE_STRING,  
      'CANCELLED_FLAG', COLUMN_NAME || '.' || VALUE_STRING,  
      'CONVERSION_TYPE_CODE', COLUMN_NAME || '.' || VALUE_STRING,  
      'CREATED_BY', COLUMN_NAME || '.' || VALUE_STRING,  
      'CUSTOMER_SIGNATURE', COLUMN_NAME || '.' || VALUE_STRING,  
      'CUSTOMER_SIGNATURE_DATE', COLUMN_NAME || '.' || VALUE_STRING,  
      'DB_FLAG', COLUMN_NAME || '.' || VALUE_STRING,  
      'DELIVER_TO_ORG_ID', COLUMN_NAME || '.' || VALUE_STRING,  
      'DEMAND_CLASS_CODE', COLUMN_NAME || '.' || VALUE_STRING,  
      'DRAFT_SUBMITTED_FLAG', COLUMN_NAME || '.' || VALUE_STRING,  
      'FLOW_STATUS_CODE', COLUMN_NAME || '.' || VALUE_STRING,  
      'FOB_POINT_CODE', COLUMN_NAME || '.' || VALUE_STRING,  
      'FREIGHT_CARRIER_CODE', COLUMN_NAME || '.' || VALUE_STRING,  
      'FULFILLED_FLAG', COLUMN_NAME || '.' || VALUE_STRING,  
      'INVOICED_FLAG', COLUMN_NAME || '.' || VALUE_STRING,  
      'INVOICE_INTERFACE_STATUS_CODE', COLUMN_NAME || '.' || VALUE_STRING,  
      'ITEM_REVISION', COLUMN_NAME || '.' || VALUE_STRING,  
      'ITEM_TYPE_CODE', COLUMN_NAME || '.' || VALUE_STRING,  
      'LINE_CATEGORY_CODE', COLUMN_NAME || '.' || VALUE_STRING,  
      'LINE_TYPE_ID', COLUMN_NAME || '.' || VALUE_STRING,  
      'LIST_LINE_TYPE_CODE', COLUMN_NAME || '.' || VALUE_STRING,  
      'MAX_RELEASE_AMOUNT', COLUMN_NAME || '.' || VALUE_STRING,  
      'MAX_RELEASE_QUANTITY', COLUMN_NAME || '.' || VALUE_STRING,  
      'MIN_RELEASE_AMOUNT', COLUMN_NAME || '.' || VALUE_STRING,  
      'MIN_RELEASE_QUANTITY', COLUMN_NAME || '.' || VALUE_STRING,  
      'ON_HOLD_FLAG', COLUMN_NAME || '.' || VALUE_STRING,  
      'OPEN_FLAG', COLUMN_NAME || '.' || VALUE_STRING,  
      'ORDERED_DATE', COLUMN_NAME || '.' || VALUE_STRING,  
      'ORDERED_QUANTITY_UOM2', COLUMN_NAME || '.' || VALUE_STRING,  
      'ORDER_CATEGORY_CODE', COLUMN_NAME || '.' || VALUE_STRING,  
      'ORDER_QUANTITY_UOM', COLUMN_NAME || '.' || VALUE_STRING,  
      'ORDER_SOURCE_ID', COLUMN_NAME || '.' || VALUE_STRING,  
      'ORDER_TYPE_ID', COLUMN_NAME || '.' || VALUE_STRING,  
      'ORG_ID', COLUMN_NAME || '.' || VALUE_STRING,  
      'OVERRIDE_AMOUNT_FLAG', COLUMN_NAME || '.' || VALUE_STRING,  
      'OVERRIDE_BLANKET_CONTROLS_FLAG', COLUMN_NAME || '.' || VALUE_STRING,  
      'OVERRIDE_RELEASE_CONTROLS_FLAG', COLUMN_NAME || '.' || VALUE_STRING,  
      'PAYMENT_AMOUNT', COLUMN_NAME || '.' || VALUE_STRING,  
      'PAYMENT_COLLECTION_EVENT', COLUMN_NAME || '.' || VALUE_STRING,  
      'PAYMENT_SET_ID', COLUMN_NAME || '.' || VALUE_STRING,  
      'PAYMENT_TERM_ID', COLUMN_NAME || '.' || VALUE_STRING, (DECODE (COLUMN_NAME,  
      'PERCENT', COLUMN_NAME || '.' || VALUE_STRING,  
      'PRICE_LIST_ID', COLUMN_NAME || '.' || VALUE_STRING,  
      'PRICING_DATE', COLUMN_NAME || '.' || VALUE_STRING,  
      'PRICING_QUANTITY', COLUMN_NAME || '.' || VALUE_STRING,  
      'PROMISE_DATE', COLUMN_NAME || '.' || VALUE_STRING,  
      'REQUEST_DATE', COLUMN_NAME || '.' || VALUE_STRING,  
      'REVISION_CHANGE_REASON_CODE', COLUMN_NAME,  
      'SALESREP_ID', COLUMN_NAME || '.' || VALUE_STRING,  
      'SALES_CREDIT_TYPE_ID', COLUMN_NAME || '.' || VALUE_STRING,  
      'SCHEDULE_ARRIVAL_DATE', COLUMN_NAME || '.' || VALUE_STRING,  
      'SCHEDULE_SHIP_DATE', COLUMN_NAME || '.' || VALUE_STRING,  
      'SHIPPED_QUANTITY', COLUMN_NAME || '.' || VALUE_STRING,  
      'SHIPPING_METHOD_CODE', COLUMN_NAME || '.' || VALUE_STRING,  
      'SHIP_FROM_ORG_ID', COLUMN_NAME || '.' || VALUE_STRING,  
      'SHIP_MODEL_COMPLETE_FLAG', COLUMN_NAME || '.' || VALUE_STRING,  
      'SHIP_TO_ORG_ID', COLUMN_NAME || '.' || VALUE_STRING,  
      'SOLD_TO_ORG_ID', COLUMN_NAME || '.' || VALUE_STRING,  
      'SOURCE_DOCUMENT_TYPE_ID', COLUMN_NAME || '.' || VALUE_STRING,  
      'SOURCE_TYPE_CODE', COLUMN_NAME || '.' || VALUE_STRING,  
      'SUPPLIER_SIGNATURE', COLUMN_NAME || '.' || VALUE_STRING,  
      'SUPPLIER_SIGNATURE_DATE', COLUMN_NAME || '.' || VALUE_STRING,  
      'TOP_MODEL_LINE_ID', COLUMN_NAME || '.' || VALUE_STRING,  
      'TRANSACTIONAL_CURR_CODE', COLUMN_NAME || '.' || VALUE_STRING,  
      'UOM_CODE', COLUMN_NAME || '.' || VALUE_STRING,  
      'UPGRADED_FLAG', COLUMN_NAME || '.' || VALUE_STRING,  
      'USER_STATUS_CODE', COLUMN_NAME || '.' || VALUE_STRING,  
      'salesrep_id', COLUMN_NAME || '.' || VALUE_STRING, NULL)))) 
 FROM OE_PC_VTMPLT_COLS

View Text - HTML Formatted

SELECT ROWID
, COLUMN_NAME
, (DECODE (COLUMN_NAME
, 'AGREEMENT_ID'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'ATO_LINE_ID'
, FND_NUMBER.CANONICAL_TO_NUMBER(VALUE_STRING)
, NULL))
, (DECODE (COLUMN_NAME
, 'AUTOMATIC_FLAG'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'BLANKET_LINE_MAX_AMOUNT'
, FND_NUMBER.CANONICAL_TO_NUMBER(VALUE_STRING)
, NULL))
, (DECODE (COLUMN_NAME
, 'BLANKET_LINE_MIN_AMOUNT'
, FND_NUMBER.CANONICAL_TO_NUMBER(VALUE_STRING)
, NULL))
, (DECODE (COLUMN_NAME
, 'BLANKET_MAX_AMOUNT'
, FND_NUMBER.CANONICAL_TO_NUMBER(VALUE_STRING)
, NULL))
, (DECODE (COLUMN_NAME
, 'BLANKET_MAX_QUANTITY'
, FND_NUMBER.CANONICAL_TO_NUMBER(VALUE_STRING)
, NULL))
, (DECODE (COLUMN_NAME
, 'BLANKET_MIN_AMOUNT'
, FND_NUMBER.CANONICAL_TO_NUMBER(VALUE_STRING)
, NULL))
, (DECODE (COLUMN_NAME
, 'BLANKET_MIN_QUANTITY'
, FND_NUMBER.CANONICAL_TO_NUMBER(VALUE_STRING)
, NULL))
, (DECODE (COLUMN_NAME
, 'BOOKED_FLAG'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'CANCELLED_FLAG'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'CONVERSION_TYPE_CODE'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'CREATED_BY'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'CUSTOMER_SIGNATURE'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'CUSTOMER_SIGNATURE_DATE'
, TO_DATE(VALUE_STRING
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (COLUMN_NAME
, 'DB_FLAG'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'DELIVER_TO_ORG_ID'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'DEMAND_CLASS_CODE'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'DRAFT_SUBMITTED_FLAG'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'FLOW_STATUS_CODE'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'FOB_POINT_CODE'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'FREIGHT_CARRIER_CODE'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'FULFILLED_FLAG'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'INVOICED_FLAG'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'INVOICE_INTERFACE_STATUS_CODE'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'ITEM_REVISION'
, FND_NUMBER.CANONICAL_TO_NUMBER(VALUE_STRING)
, NULL))
, (DECODE (COLUMN_NAME
, 'ITEM_TYPE_CODE'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'LINE_CATEGORY_CODE'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'LINE_TYPE_ID'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'LIST_LINE_TYPE_CODE'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'MAX_RELEASE_AMOUNT'
, FND_NUMBER.CANONICAL_TO_NUMBER(VALUE_STRING)
, NULL))
, (DECODE (COLUMN_NAME
, 'MAX_RELEASE_QUANTITY'
, FND_NUMBER.CANONICAL_TO_NUMBER(VALUE_STRING)
, NULL))
, (DECODE (COLUMN_NAME
, 'MIN_RELEASE_AMOUNT'
, FND_NUMBER.CANONICAL_TO_NUMBER(VALUE_STRING)
, NULL))
, (DECODE (COLUMN_NAME
, 'MIN_RELEASE_QUANTITY'
, FND_NUMBER.CANONICAL_TO_NUMBER(VALUE_STRING)
, NULL))
, (DECODE (COLUMN_NAME
, 'ON_HOLD_FLAG'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'OPEN_FLAG'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'ORDERED_DATE'
, TO_DATE(VALUE_STRING
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (COLUMN_NAME
, 'ORDERED_QUANTITY_UOM2'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'ORDER_CATEGORY_CODE'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'UOM_CODE'
, VALUE_STRING
, 'ORDER_QUANTITY_UOM'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'ORDER_SOURCE_ID'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'ORDER_TYPE_ID'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'ORG_ID'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'OVERRIDE_AMOUNT_FLAG'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'OVERRIDE_BLANKET_CONTROLS_FLAG'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'OVERRIDE_RELEASE_CONTROLS_FLAG'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'PAYMENT_AMOUNT'
, FND_NUMBER.CANONICAL_TO_NUMBER(VALUE_STRING)
, NULL))
, (DECODE (COLUMN_NAME
, 'PAYMENT_COLLECTION_EVENT'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'PAYMENT_SET_ID'
, FND_NUMBER.CANONICAL_TO_NUMBER(VALUE_STRING)
, NULL))
, (DECODE (COLUMN_NAME
, 'PAYMENT_TERM_ID'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'PERCENT'
, FND_NUMBER.CANONICAL_TO_NUMBER(VALUE_STRING)
, NULL))
, (DECODE (COLUMN_NAME
, 'PRICE_LIST_ID'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'PRICING_DATE'
, TO_DATE(VALUE_STRING
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (COLUMN_NAME
, 'PRICING_QUANTITY'
, FND_NUMBER.CANONICAL_TO_NUMBER(VALUE_STRING)
, NULL))
, (DECODE (COLUMN_NAME
, 'PROMISE_DATE'
, TO_DATE(VALUE_STRING
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (COLUMN_NAME
, 'REQUEST_DATE'
, TO_DATE(VALUE_STRING
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (COLUMN_NAME
, 'SALESREP_ID'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'SALES_CREDIT_TYPE_ID'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'SCHEDULE_ARRIVAL_DATE'
, TO_DATE(VALUE_STRING
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (COLUMN_NAME
, 'SCHEDULE_SHIP_DATE'
, TO_DATE(VALUE_STRING
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (COLUMN_NAME
, 'SHIPPED_QUANTITY'
, FND_NUMBER.CANONICAL_TO_NUMBER(VALUE_STRING)
, NULL))
, (DECODE (COLUMN_NAME
, 'SHIPPING_METHOD_CODE'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'SHIP_FROM_ORG_ID'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'SHIP_MODEL_COMPLETE_FLAG'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'SHIP_TO_ORG_ID'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'SOLD_TO_ORG_ID'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'SOURCE_DOCUMENT_TYPE_ID'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'SOURCE_TYPE_CODE'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'SUPPLIER_SIGNATURE'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'SUPPLIER_SIGNATURE_DATE'
, TO_DATE(VALUE_STRING
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (COLUMN_NAME
, 'TOP_MODEL_LINE_ID'
, FND_NUMBER.CANONICAL_TO_NUMBER(VALUE_STRING)
, NULL))
, (DECODE (COLUMN_NAME
, 'TRANSACTIONAL_CURR_CODE'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'UPGRADED_FLAG'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'USER_STATUS_CODE'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'SALESREP_ID'
, VALUE_STRING
, NULL))
, (DECODE (COLUMN_NAME
, 'AGREEMENT_ID'
, COLUMN_NAME || '.' || VALUE_STRING
, 'ATO_LINE_ID'
, COLUMN_NAME || '.' || VALUE_STRING
, 'AUTOMATIC_FLAG'
, COLUMN_NAME || '.' || VALUE_STRING
, 'BLANKET_LINE_MAX_AMOUNT'
, COLUMN_NAME || '.' || VALUE_STRING
, 'BLANKET_LINE_MIN_AMOUNT'
, COLUMN_NAME || '.' || VALUE_STRING
, 'BLANKET_MAX_AMOUNT'
, COLUMN_NAME || '.' || VALUE_STRING
, 'BLANKET_MAX_QUANTITY'
, COLUMN_NAME || '.' || VALUE_STRING
, 'BLANKET_MIN_AMOUNT'
, COLUMN_NAME || '.' || VALUE_STRING
, 'BLANKET_MIN_QUANTITY'
, COLUMN_NAME || '.' || VALUE_STRING
, 'BOOKED_FLAG'
, COLUMN_NAME || '.' || VALUE_STRING
, 'CANCELLED_FLAG'
, COLUMN_NAME || '.' || VALUE_STRING
, 'CONVERSION_TYPE_CODE'
, COLUMN_NAME || '.' || VALUE_STRING
, 'CREATED_BY'
, COLUMN_NAME || '.' || VALUE_STRING
, 'CUSTOMER_SIGNATURE'
, COLUMN_NAME || '.' || VALUE_STRING
, 'CUSTOMER_SIGNATURE_DATE'
, COLUMN_NAME || '.' || VALUE_STRING
, 'DB_FLAG'
, COLUMN_NAME || '.' || VALUE_STRING
, 'DELIVER_TO_ORG_ID'
, COLUMN_NAME || '.' || VALUE_STRING
, 'DEMAND_CLASS_CODE'
, COLUMN_NAME || '.' || VALUE_STRING
, 'DRAFT_SUBMITTED_FLAG'
, COLUMN_NAME || '.' || VALUE_STRING
, 'FLOW_STATUS_CODE'
, COLUMN_NAME || '.' || VALUE_STRING
, 'FOB_POINT_CODE'
, COLUMN_NAME || '.' || VALUE_STRING
, 'FREIGHT_CARRIER_CODE'
, COLUMN_NAME || '.' || VALUE_STRING
, 'FULFILLED_FLAG'
, COLUMN_NAME || '.' || VALUE_STRING
, 'INVOICED_FLAG'
, COLUMN_NAME || '.' || VALUE_STRING
, 'INVOICE_INTERFACE_STATUS_CODE'
, COLUMN_NAME || '.' || VALUE_STRING
, 'ITEM_REVISION'
, COLUMN_NAME || '.' || VALUE_STRING
, 'ITEM_TYPE_CODE'
, COLUMN_NAME || '.' || VALUE_STRING
, 'LINE_CATEGORY_CODE'
, COLUMN_NAME || '.' || VALUE_STRING
, 'LINE_TYPE_ID'
, COLUMN_NAME || '.' || VALUE_STRING
, 'LIST_LINE_TYPE_CODE'
, COLUMN_NAME || '.' || VALUE_STRING
, 'MAX_RELEASE_AMOUNT'
, COLUMN_NAME || '.' || VALUE_STRING
, 'MAX_RELEASE_QUANTITY'
, COLUMN_NAME || '.' || VALUE_STRING
, 'MIN_RELEASE_AMOUNT'
, COLUMN_NAME || '.' || VALUE_STRING
, 'MIN_RELEASE_QUANTITY'
, COLUMN_NAME || '.' || VALUE_STRING
, 'ON_HOLD_FLAG'
, COLUMN_NAME || '.' || VALUE_STRING
, 'OPEN_FLAG'
, COLUMN_NAME || '.' || VALUE_STRING
, 'ORDERED_DATE'
, COLUMN_NAME || '.' || VALUE_STRING
, 'ORDERED_QUANTITY_UOM2'
, COLUMN_NAME || '.' || VALUE_STRING
, 'ORDER_CATEGORY_CODE'
, COLUMN_NAME || '.' || VALUE_STRING
, 'ORDER_QUANTITY_UOM'
, COLUMN_NAME || '.' || VALUE_STRING
, 'ORDER_SOURCE_ID'
, COLUMN_NAME || '.' || VALUE_STRING
, 'ORDER_TYPE_ID'
, COLUMN_NAME || '.' || VALUE_STRING
, 'ORG_ID'
, COLUMN_NAME || '.' || VALUE_STRING
, 'OVERRIDE_AMOUNT_FLAG'
, COLUMN_NAME || '.' || VALUE_STRING
, 'OVERRIDE_BLANKET_CONTROLS_FLAG'
, COLUMN_NAME || '.' || VALUE_STRING
, 'OVERRIDE_RELEASE_CONTROLS_FLAG'
, COLUMN_NAME || '.' || VALUE_STRING
, 'PAYMENT_AMOUNT'
, COLUMN_NAME || '.' || VALUE_STRING
, 'PAYMENT_COLLECTION_EVENT'
, COLUMN_NAME || '.' || VALUE_STRING
, 'PAYMENT_SET_ID'
, COLUMN_NAME || '.' || VALUE_STRING
, 'PAYMENT_TERM_ID'
, COLUMN_NAME || '.' || VALUE_STRING
, (DECODE (COLUMN_NAME
, 'PERCENT'
, COLUMN_NAME || '.' || VALUE_STRING
, 'PRICE_LIST_ID'
, COLUMN_NAME || '.' || VALUE_STRING
, 'PRICING_DATE'
, COLUMN_NAME || '.' || VALUE_STRING
, 'PRICING_QUANTITY'
, COLUMN_NAME || '.' || VALUE_STRING
, 'PROMISE_DATE'
, COLUMN_NAME || '.' || VALUE_STRING
, 'REQUEST_DATE'
, COLUMN_NAME || '.' || VALUE_STRING
, 'REVISION_CHANGE_REASON_CODE'
, COLUMN_NAME
, 'SALESREP_ID'
, COLUMN_NAME || '.' || VALUE_STRING
, 'SALES_CREDIT_TYPE_ID'
, COLUMN_NAME || '.' || VALUE_STRING
, 'SCHEDULE_ARRIVAL_DATE'
, COLUMN_NAME || '.' || VALUE_STRING
, 'SCHEDULE_SHIP_DATE'
, COLUMN_NAME || '.' || VALUE_STRING
, 'SHIPPED_QUANTITY'
, COLUMN_NAME || '.' || VALUE_STRING
, 'SHIPPING_METHOD_CODE'
, COLUMN_NAME || '.' || VALUE_STRING
, 'SHIP_FROM_ORG_ID'
, COLUMN_NAME || '.' || VALUE_STRING
, 'SHIP_MODEL_COMPLETE_FLAG'
, COLUMN_NAME || '.' || VALUE_STRING
, 'SHIP_TO_ORG_ID'
, COLUMN_NAME || '.' || VALUE_STRING
, 'SOLD_TO_ORG_ID'
, COLUMN_NAME || '.' || VALUE_STRING
, 'SOURCE_DOCUMENT_TYPE_ID'
, COLUMN_NAME || '.' || VALUE_STRING
, 'SOURCE_TYPE_CODE'
, COLUMN_NAME || '.' || VALUE_STRING
, 'SUPPLIER_SIGNATURE'
, COLUMN_NAME || '.' || VALUE_STRING
, 'SUPPLIER_SIGNATURE_DATE'
, COLUMN_NAME || '.' || VALUE_STRING
, 'TOP_MODEL_LINE_ID'
, COLUMN_NAME || '.' || VALUE_STRING
, 'TRANSACTIONAL_CURR_CODE'
, COLUMN_NAME || '.' || VALUE_STRING
, 'UOM_CODE'
, COLUMN_NAME || '.' || VALUE_STRING
, 'UPGRADED_FLAG'
, COLUMN_NAME || '.' || VALUE_STRING
, 'USER_STATUS_CODE'
, COLUMN_NAME || '.' || VALUE_STRING
, 'SALESREP_ID'
, COLUMN_NAME || '.' || VALUE_STRING
, NULL))))
FROM OE_PC_VTMPLT_COLS