Advertisement
VoronVU

Untitled

Apr 7th, 2015
1,168
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. TYPE tb1_res IS RECORD (  
  2.   path  VARCHAR2(255),
  3.   channel_name VARCHAR2(255),
  4.   channel_code VARCHAR2(255),
  5.   issue_usedate NUMBER,
  6.   mnth VARCHAR2(255),
  7.   is_dt DATE,
  8.   o_channel_id NUMBER,
  9.   cnt_copy NUMBER,
  10.   ordtl NUMBER,
  11.   ordetl NUMBER,
  12.   ordsg NUMBER,
  13.   ordesg NUMBER,
  14.   sbstl NUMBER,
  15.   sbssg NUMBER,
  16.   sbsda NUMBER,
  17.   sbstotal NUMBER,
  18.   fulltl NUMBER,
  19.   fullsg NUMBER,
  20.   fullda NUMBER,
  21.   fulltotal NUMBER,
  22.   coursetotal NUMBER,
  23.   totalorders NUMBER,
  24.   channel_id NUMBER,
  25.   issue_date DATE,
  26.   amount_tm_tl NUMBER,
  27.   amount_tm_tl_course NUMBER,
  28.   amount_r1_tl NUMBER,
  29.   amount_r1_tl_course NUMBER,
  30.   amount_r1e_tl NUMBER,
  31.   amount_r1e_tl_course NUMBER,
  32.   amount_r2_tl NUMBER,
  33.   amount_r2_tl_course NUMBER,
  34.   amount_r2e_tl NUMBER,
  35.   amount_r2e_tl_course NUMBER,
  36.   amount_r3_tl NUMBER,
  37.   amount_r3_tl_course NUMBER,
  38.   amount_r3e_tl NUMBER,
  39.   amount_r3e_tl_course NUMBER,
  40.   amount_tm_etl NUMBER,
  41.   amount_tm_etl_course NUMBER,
  42.   amount_r0e_etl NUMBER,
  43.   amount_r0e_etl_course NUMBER,
  44.   amount_r1e_etl NUMBER,
  45.   amount_r1e_etl_course NUMBER,
  46.   amount_r2e_etl NUMBER,
  47.   amount_r2e_etl_course NUMBER,
  48.   amount_r3e_etl NUMBER,
  49.   amount_r3e_etl_course NUMBER
  50. );
Advertisement
RAW Paste Data Copied
Advertisement