Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- TYPE tb1_res IS RECORD (
- path VARCHAR2(255),
- channel_name VARCHAR2(255),
- channel_code VARCHAR2(255),
- issue_usedate NUMBER,
- mnth VARCHAR2(255),
- is_dt DATE,
- o_channel_id NUMBER,
- cnt_copy NUMBER,
- ordtl NUMBER,
- ordetl NUMBER,
- ordsg NUMBER,
- ordesg NUMBER,
- sbstl NUMBER,
- sbssg NUMBER,
- sbsda NUMBER,
- sbstotal NUMBER,
- fulltl NUMBER,
- fullsg NUMBER,
- fullda NUMBER,
- fulltotal NUMBER,
- coursetotal NUMBER,
- totalorders NUMBER,
- channel_id NUMBER,
- issue_date DATE,
- amount_tm_tl NUMBER,
- amount_tm_tl_course NUMBER,
- amount_r1_tl NUMBER,
- amount_r1_tl_course NUMBER,
- amount_r1e_tl NUMBER,
- amount_r1e_tl_course NUMBER,
- amount_r2_tl NUMBER,
- amount_r2_tl_course NUMBER,
- amount_r2e_tl NUMBER,
- amount_r2e_tl_course NUMBER,
- amount_r3_tl NUMBER,
- amount_r3_tl_course NUMBER,
- amount_r3e_tl NUMBER,
- amount_r3e_tl_course NUMBER,
- amount_tm_etl NUMBER,
- amount_tm_etl_course NUMBER,
- amount_r0e_etl NUMBER,
- amount_r0e_etl_course NUMBER,
- amount_r1e_etl NUMBER,
- amount_r1e_etl_course NUMBER,
- amount_r2e_etl NUMBER,
- amount_r2e_etl_course NUMBER,
- amount_r3e_etl NUMBER,
- amount_r3e_etl_course NUMBER
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement