eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QPR_CREATE_DEMO_DATA dependencies on QPR_TRANSF_HEADERS_B

Line 128227: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",

128223:
128224: --- inserting headers ----
128225: --- LOW VOLUME - 101 -----
128226: INSERT
128227: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",
128228: "FROM_DIM_MEAS_CODE", "FROM_DIM_HIER_CODE", "LIMIT_DIM_FLAG",
128229: "FROM_LEVEL_ID", "MEAS_CODE", "TO_DIM_CODE", "TO_HIER_CODE",
128230: "TO_LEVEL_ID", "TO_VALUE", "TO_VALUE_DESC", "CREATED_BY",
128231: "CREATION_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",

Line 128275: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",

128271:
128272: ---- LOW_MEDIUM 102 ----
128273:
128274: INSERT
128275: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",
128276: "FROM_DIM_MEAS_CODE", "FROM_DIM_HIER_CODE", "LIMIT_DIM_FLAG",
128277: "FROM_LEVEL_ID", "MEAS_CODE", "TO_DIM_CODE", "TO_HIER_CODE",
128278: "TO_LEVEL_ID", "TO_VALUE", "TO_VALUE_DESC", "CREATED_BY",
128279: "CREATION_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",

Line 128326: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",

128322:
128323: --- MEDIUM - 103 ---
128324:
128325: INSERT
128326: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",
128327: "FROM_DIM_MEAS_CODE", "FROM_DIM_HIER_CODE", "LIMIT_DIM_FLAG",
128328: "FROM_LEVEL_ID", "MEAS_CODE", "TO_DIM_CODE", "TO_HIER_CODE",
128329: "TO_LEVEL_ID", "TO_VALUE", "TO_VALUE_DESC", "CREATED_BY",
128330: "CREATION_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",

Line 128376: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",

128372:
128373: -- MED_HIG - 104 ---
128374:
128375: INSERT
128376: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",
128377: "FROM_DIM_MEAS_CODE", "FROM_DIM_HIER_CODE", "LIMIT_DIM_FLAG",
128378: "FROM_LEVEL_ID", "MEAS_CODE", "TO_DIM_CODE", "TO_HIER_CODE",
128379: "TO_LEVEL_ID", "TO_VALUE", "TO_VALUE_DESC", "CREATED_BY",
128380: "CREATION_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",

Line 128426: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",

128422: from fnd_languages l where l.installed_flag in ('B', 'I');
128423:
128424: --- HIGH 105 ---
128425: INSERT
128426: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",
128427: "FROM_DIM_MEAS_CODE", "FROM_DIM_HIER_CODE", "LIMIT_DIM_FLAG",
128428: "FROM_LEVEL_ID", "MEAS_CODE", "TO_DIM_CODE", "TO_HIER_CODE",
128429: "TO_LEVEL_ID", "TO_VALUE", "TO_VALUE_DESC", "CREATED_BY",
128430: "CREATION_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",

Line 128509: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",

128505:
128506: /***** inserting headers *******/
128507: /******** Standard price *******/
128508: INSERT
128509: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",
128510: "FROM_DIM_MEAS_CODE", "FROM_DIM_HIER_CODE", "LIMIT_DIM_FLAG",
128511: "FROM_LEVEL_ID", "MEAS_CODE", "TO_DIM_CODE", "TO_HIER_CODE",
128512: "TO_LEVEL_ID", "TO_VALUE", "TO_VALUE_DESC", "CREATED_BY",
128513: "CREATION_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",

Line 128554: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",

128550: from fnd_languages l where l.installed_flag in ('B', 'I');
128551:
128552: /******* Standard Volume ***********/
128553: INSERT
128554: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",
128555: "FROM_DIM_MEAS_CODE", "FROM_DIM_HIER_CODE", "LIMIT_DIM_FLAG",
128556: "FROM_LEVEL_ID", "MEAS_CODE", "TO_DIM_CODE", "TO_HIER_CODE",
128557: "TO_LEVEL_ID", "TO_VALUE", "TO_VALUE_DESC", "CREATED_BY",
128558: "CREATION_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",

Line 128601: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",

128597: from fnd_languages l where l.installed_flag in ('B', 'I');
128598:
128599: /*******Standard Promo ************/
128600: INSERT
128601: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",
128602: "FROM_DIM_MEAS_CODE", "FROM_DIM_HIER_CODE", "LIMIT_DIM_FLAG",
128603: "FROM_LEVEL_ID", "MEAS_CODE", "TO_DIM_CODE", "TO_HIER_CODE",
128604: "TO_LEVEL_ID", "TO_VALUE", "TO_VALUE_DESC", "CREATED_BY",
128605: "CREATION_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",

Line 128648: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",

128644: from fnd_languages l where l.installed_flag in ('B', 'I');
128645:
128646: /**standard Order Value **********/
128647: INSERT
128648: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",
128649: "FROM_DIM_MEAS_CODE", "FROM_DIM_HIER_CODE", "LIMIT_DIM_FLAG",
128650: "FROM_LEVEL_ID", "MEAS_CODE", "TO_DIM_CODE", "TO_HIER_CODE",
128651: "TO_LEVEL_ID", "TO_VALUE", "TO_VALUE_DESC", "CREATED_BY",
128652: "CREATION_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",

Line 128696: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",

128692:
128693: /****STandard Lumpsum **************/
128694:
128695: INSERT
128696: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",
128697: "FROM_DIM_MEAS_CODE", "FROM_DIM_HIER_CODE", "LIMIT_DIM_FLAG",
128698: "FROM_LEVEL_ID", "MEAS_CODE", "TO_DIM_CODE", "TO_HIER_CODE",
128699: "TO_LEVEL_ID", "TO_VALUE", "TO_VALUE_DESC", "CREATED_BY",
128700: "CREATION_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",

Line 128742: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",

128738: from fnd_languages l where l.installed_flag in ('B', 'I');
128739:
128740: /******STANdard F and S ***************/
128741: INSERT
128742: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",
128743: "FROM_DIM_MEAS_CODE", "FROM_DIM_HIER_CODE", "LIMIT_DIM_FLAG",
128744: "FROM_LEVEL_ID", "MEAS_CODE", "TO_DIM_CODE", "TO_HIER_CODE",
128745: "TO_LEVEL_ID", "TO_VALUE", "TO_VALUE_DESC", "CREATED_BY",
128746: "CREATION_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",

Line 128792: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",

128788: from fnd_languages l where l.installed_flag in ('B', 'I');
128789:
128790: /*******USER Price ********************/
128791: INSERT
128792: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",
128793: "FROM_DIM_MEAS_CODE", "FROM_DIM_HIER_CODE", "LIMIT_DIM_FLAG",
128794: "FROM_LEVEL_ID", "MEAS_CODE", "TO_DIM_CODE", "TO_HIER_CODE",
128795: "TO_LEVEL_ID", "TO_VALUE", "TO_VALUE_DESC", "CREATED_BY",
128796: "CREATION_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",

Line 128839: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",

128835: SYSDATE, 2, 2, NULL, NULL, NULL, NULL
128836: from fnd_languages l where l.installed_flag in ('B', 'I');
128837: /*******User Volume ***********/
128838: INSERT
128839: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",
128840: "FROM_DIM_MEAS_CODE", "FROM_DIM_HIER_CODE", "LIMIT_DIM_FLAG",
128841: "FROM_LEVEL_ID", "MEAS_CODE", "TO_DIM_CODE", "TO_HIER_CODE",
128842: "TO_LEVEL_ID", "TO_VALUE", "TO_VALUE_DESC", "CREATED_BY",
128843: "CREATION_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",

Line 128887: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",

128883: from fnd_languages l where l.installed_flag in ('B', 'I');
128884:
128885: /*****User Promo ***********/
128886: INSERT
128887: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",
128888: "FROM_DIM_MEAS_CODE", "FROM_DIM_HIER_CODE", "LIMIT_DIM_FLAG",
128889: "FROM_LEVEL_ID", "MEAS_CODE", "TO_DIM_CODE", "TO_HIER_CODE",
128890: "TO_LEVEL_ID", "TO_VALUE", "TO_VALUE_DESC", "CREATED_BY",
128891: "CREATION_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",

Line 128935: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",

128931: from fnd_languages l where l.installed_flag in ('B', 'I');
128932:
128933: /***User Lumpsum **********/
128934: INSERT
128935: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",
128936: "FROM_DIM_MEAS_CODE", "FROM_DIM_HIER_CODE", "LIMIT_DIM_FLAG",
128937: "FROM_LEVEL_ID", "MEAS_CODE", "TO_DIM_CODE", "TO_HIER_CODE",
128938: "TO_LEVEL_ID", "TO_VALUE", "TO_VALUE_DESC", "CREATED_BY",
128939: "CREATION_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",

Line 129017: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",

129013:
129014: /****************** inserting headers ****************/
129015: /* Contract PRICE ************/
129016: INSERT
129017: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",
129018: "FROM_DIM_MEAS_CODE", "FROM_DIM_HIER_CODE", "LIMIT_DIM_FLAG",
129019: "FROM_LEVEL_ID", "MEAS_CODE", "TO_DIM_CODE", "TO_HIER_CODE",
129020: "TO_LEVEL_ID", "TO_VALUE", "TO_VALUE_DESC", "CREATED_BY",
129021: "CREATION_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",

Line 129064: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",

129060: from fnd_languages l where l.installed_flag in ('B', 'I');
129061:
129062: /******** COntract Volume ************/
129063: INSERT
129064: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",
129065: "FROM_DIM_MEAS_CODE", "FROM_DIM_HIER_CODE", "LIMIT_DIM_FLAG",
129066: "FROM_LEVEL_ID", "MEAS_CODE", "TO_DIM_CODE", "TO_HIER_CODE",
129067: "TO_LEVEL_ID", "TO_VALUE", "TO_VALUE_DESC", "CREATED_BY",
129068: "CREATION_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",

Line 129112: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",

129108: from fnd_languages l where l.installed_flag in ('B', 'I');
129109:
129110: /*Contract Promo *************************/
129111: INSERT
129112: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",
129113: "FROM_DIM_MEAS_CODE", "FROM_DIM_HIER_CODE", "LIMIT_DIM_FLAG",
129114: "FROM_LEVEL_ID", "MEAS_CODE", "TO_DIM_CODE", "TO_HIER_CODE",
129115: "TO_LEVEL_ID", "TO_VALUE", "TO_VALUE_DESC", "CREATED_BY",
129116: "CREATION_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",

Line 129161: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",

129157: from fnd_languages l where l.installed_flag in ('B', 'I');
129158:
129159: /* Contract Order Value *****************/
129160: INSERT
129161: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",
129162: "FROM_DIM_MEAS_CODE", "FROM_DIM_HIER_CODE", "LIMIT_DIM_FLAG",
129163: "FROM_LEVEL_ID", "MEAS_CODE", "TO_DIM_CODE", "TO_HIER_CODE",
129164: "TO_LEVEL_ID", "TO_VALUE", "TO_VALUE_DESC", "CREATED_BY",
129165: "CREATION_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",

Line 129206: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",

129202: SYSDATE, 2, SYSDATE, 2, 2, NULL, NULL, NULL, NULL
129203: from fnd_languages l where l.installed_flag in ('B', 'I');
129204: /***** Contract Lumpsum **********/
129205: INSERT
129206: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",
129207: "FROM_DIM_MEAS_CODE", "FROM_DIM_HIER_CODE", "LIMIT_DIM_FLAG",
129208: "FROM_LEVEL_ID", "MEAS_CODE", "TO_DIM_CODE", "TO_HIER_CODE",
129209: "TO_LEVEL_ID", "TO_VALUE", "TO_VALUE_DESC", "CREATED_BY",
129210: "CREATION_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",

Line 129254: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",

129250: from fnd_languages l where l.installed_flag in ('B', 'I');
129251:
129252: /* Contract FS ******************/
129253: INSERT
129254: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",
129255: "FROM_DIM_MEAS_CODE", "FROM_DIM_HIER_CODE", "LIMIT_DIM_FLAG",
129256: "FROM_LEVEL_ID", "MEAS_CODE", "TO_DIM_CODE", "TO_HIER_CODE",
129257: "TO_LEVEL_ID", "TO_VALUE", "TO_VALUE_DESC", "CREATED_BY",
129258: "CREATION_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",

Line 129340: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",

129336: from fnd_languages l where l.installed_flag in ('B', 'I');
129337: /* inserting headers */
129338: /*************** STANDARD ADJ *************************/
129339: INSERT
129340: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",
129341: "FROM_DIM_MEAS_CODE", "FROM_DIM_HIER_CODE", "LIMIT_DIM_FLAG",
129342: "FROM_LEVEL_ID", "MEAS_CODE", "TO_DIM_CODE", "TO_HIER_CODE",
129343: "TO_LEVEL_ID", "TO_VALUE", "TO_VALUE_DESC", "CREATED_BY",
129344: "CREATION_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",

Line 129389: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",

129385: from fnd_languages l where l.installed_flag in ('B', 'I');
129386:
129387: /**************** USER ADJ ******************/
129388: INSERT
129389: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",
129390: "FROM_DIM_MEAS_CODE", "FROM_DIM_HIER_CODE", "LIMIT_DIM_FLAG",
129391: "FROM_LEVEL_ID", "MEAS_CODE", "TO_DIM_CODE", "TO_HIER_CODE",
129392: "TO_LEVEL_ID", "TO_VALUE", "TO_VALUE_DESC", "CREATED_BY",
129393: "CREATION_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",

Line 129438: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",

129434: from fnd_languages l where l.installed_flag in ('B', 'I');
129435:
129436: /********* CONTRACTS ADJ ******************/
129437: INSERT
129438: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",
129439: "FROM_DIM_MEAS_CODE", "FROM_DIM_HIER_CODE", "LIMIT_DIM_FLAG",
129440: "FROM_LEVEL_ID", "MEAS_CODE", "TO_DIM_CODE", "TO_HIER_CODE",
129441: "TO_LEVEL_ID", "TO_VALUE", "TO_VALUE_DESC", "CREATED_BY",
129442: "CREATION_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",