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_PR_SEGMENTS_S

Line 127837: (qpr_pr_segments_s.nextval,l_instance_id,qpr_policies_s.currval,'HIGH',1,

127833: "CREATED_BY","LAST_UPDATE_DATE","LAST_UPDATED_BY",
127834: "LAST_UPDATE_LOGIN","PROGRAM_ID","PROGRAM_LOGIN_ID",
127835: "PROGRAM_APPLICATION_ID","REQUEST_ID")
127836: values
127837: (qpr_pr_segments_s.nextval,l_instance_id,qpr_policies_s.currval,'HIGH',1,
127838: sysdate,1319,sysdate,1318,4943151,null,null,null,null);
127839:
127840: Insert into qpr_pr_segments_tl
127841: ("PR_SEGMENT_ID","LANGUAGE","SOURCE_LANG",

Line 127846: select qpr_pr_segments_s.currval,l.language_code,'US',

127842: "NAME","DESCRIPTION","CREATION_DATE",
127843: "CREATED_BY","LAST_UPDATE_DATE","LAST_UPDATED_BY",
127844: "LAST_UPDATE_LOGIN","PROGRAM_ID","PROGRAM_LOGIN_ID",
127845: "PROGRAM_APPLICATION_ID","REQUEST_ID")
127846: select qpr_pr_segments_s.currval,l.language_code,'US',
127847: 'Strategics - Commercial','Strategics - Commercial',
127848: sysdate,1318,sysdate,1318,4941072,1,1,1,1
127849: from fnd_languages l where l.installed_flag in ('B','I');
127850:

Line 127851: select qpr_pr_segments_s.currval into psg_level1_value from dual;

127847: 'Strategics - Commercial','Strategics - Commercial',
127848: sysdate,1318,sysdate,1318,4941072,1,1,1,1
127849: from fnd_languages l where l.installed_flag in ('B','I');
127850:
127851: select qpr_pr_segments_s.currval into psg_level1_value from dual;
127852:
127853: insert_psg_dim_value(psg_level1_value, 'Strategics - Commercial', l_instance_id);
127854:
127855: Insert into qpr_scopes

Line 127863: (qpr_scopes_s.nextval,'PRICINGSEGMENT',qpr_pr_segments_s.currval,

127859: "CREATED_BY","CREATION_DATE","LAST_UPDATED_BY",
127860: "LAST_UPDATE_DATE","LAST_UPDATE_LOGIN","PROGRAM_ID",
127861: "PROGRAM_LOGIN_ID","PROGRAM_APPLICATION_ID","REQUEST_ID")
127862: values
127863: (qpr_scopes_s.nextval,'PRICINGSEGMENT',qpr_pr_segments_s.currval,
127864: 'CUS',7,22,'=','103','Strategics - Commercial',1318,
127865: sysdate,1318,sysdate,4941553,null,null,null,null);
127866:
127867: end if;

Line 127939: (qpr_pr_segments_s.nextval,l_instance_id,qpr_policies_s.currval,'HIGH',1,

127935: "CREATED_BY","LAST_UPDATE_DATE","LAST_UPDATED_BY",
127936: "LAST_UPDATE_LOGIN","PROGRAM_ID","PROGRAM_LOGIN_ID",
127937: "PROGRAM_APPLICATION_ID","REQUEST_ID")
127938: values
127939: (qpr_pr_segments_s.nextval,l_instance_id,qpr_policies_s.currval,'HIGH',1,
127940: sysdate,1329,sysdate,1318,4959806,null,null,null,null);
127941:
127942: Insert into qpr_pr_segments_tl
127943: ("PR_SEGMENT_ID","LANGUAGE","SOURCE_LANG",

Line 127949: qpr_pr_segments_s.currval,l.language_code,'US','Strategics - Retail',

127945: "CREATED_BY","LAST_UPDATE_DATE","LAST_UPDATED_BY",
127946: "LAST_UPDATE_LOGIN","PROGRAM_ID","PROGRAM_LOGIN_ID",
127947: "PROGRAM_APPLICATION_ID","REQUEST_ID")
127948: select
127949: qpr_pr_segments_s.currval,l.language_code,'US','Strategics - Retail',
127950: 'Strategics - Retail',
127951: sysdate,1318,sysdate,1318,4941036,1,1,1,1
127952: from fnd_languages l where l.installed_flag in ('B','I');
127953:

Line 127954: select qpr_pr_segments_s.currval into psg_level1_value from dual;

127950: 'Strategics - Retail',
127951: sysdate,1318,sysdate,1318,4941036,1,1,1,1
127952: from fnd_languages l where l.installed_flag in ('B','I');
127953:
127954: select qpr_pr_segments_s.currval into psg_level1_value from dual;
127955: insert_psg_dim_value(psg_level1_value, 'Strategics - Retail', l_instance_id);
127956:
127957: Insert into qpr_scopes
127958: ("SCOPE_ID","PARENT_ENTITY_TYPE","PARENT_ID",

Line 127965: (qpr_scopes_s.nextval,'PRICINGSEGMENT',qpr_pr_segments_s.currval,

127961: "CREATED_BY","CREATION_DATE","LAST_UPDATED_BY",
127962: "LAST_UPDATE_DATE","LAST_UPDATE_LOGIN","PROGRAM_ID",
127963: "PROGRAM_LOGIN_ID","PROGRAM_APPLICATION_ID","REQUEST_ID")
127964: values
127965: (qpr_scopes_s.nextval,'PRICINGSEGMENT',qpr_pr_segments_s.currval,
127966: 'CUS',7,22,'=','101','Strategics - Retail',1318,
127967: sysdate,1318,sysdate,4941553,null,null,null,null);
127968:
127969: end if;

Line 128045: (qpr_pr_segments_s.nextval,l_instance_id,qpr_policies_s.currval,'HIGH',1,

128041: "CREATED_BY","LAST_UPDATE_DATE","LAST_UPDATED_BY",
128042: "LAST_UPDATE_LOGIN","PROGRAM_ID","PROGRAM_LOGIN_ID",
128043: "PROGRAM_APPLICATION_ID","REQUEST_ID")
128044: values
128045: (qpr_pr_segments_s.nextval,l_instance_id,qpr_policies_s.currval,'HIGH',1,
128046: sysdate,1321,sysdate,1318,4959719,null,null,null,null);
128047:
128048: Insert into qpr_pr_segments_tl
128049: ("PR_SEGMENT_ID","LANGUAGE","SOURCE_LANG",

Line 128055: qpr_pr_segments_s.currval,l.language_code,'US','Computers',null,

128051: "CREATED_BY","LAST_UPDATE_DATE","LAST_UPDATED_BY",
128052: "LAST_UPDATE_LOGIN","PROGRAM_ID","PROGRAM_LOGIN_ID",
128053: "PROGRAM_APPLICATION_ID","REQUEST_ID")
128054: select
128055: qpr_pr_segments_s.currval,l.language_code,'US','Computers',null,
128056: sysdate,1318,sysdate,1318,4959698,1,1,1,1
128057: from fnd_languages l where l.installed_flag in ('B','I');
128058:
128059: select qpr_pr_segments_s.currval into psg_level1_value from dual;

Line 128059: select qpr_pr_segments_s.currval into psg_level1_value from dual;

128055: qpr_pr_segments_s.currval,l.language_code,'US','Computers',null,
128056: sysdate,1318,sysdate,1318,4959698,1,1,1,1
128057: from fnd_languages l where l.installed_flag in ('B','I');
128058:
128059: select qpr_pr_segments_s.currval into psg_level1_value from dual;
128060: insert_psg_dim_value(psg_level1_value, 'Computers', l_instance_id);
128061:
128062: Insert into qpr_scopes
128063: ("SCOPE_ID","PARENT_ENTITY_TYPE","PARENT_ID",

Line 128070: (qpr_scopes_s.nextval,'PRICINGSEGMENT',qpr_pr_segments_s.currval,

128066: "CREATED_BY","CREATION_DATE","LAST_UPDATED_BY",
128067: "LAST_UPDATE_DATE","LAST_UPDATE_LOGIN","PROGRAM_ID",
128068: "PROGRAM_LOGIN_ID","PROGRAM_APPLICATION_ID","REQUEST_ID")
128069: values
128070: (qpr_scopes_s.nextval,'PRICINGSEGMENT',qpr_pr_segments_s.currval,
128071: 'PRD',4,9,'=','101','Computers',1318,
128072: sysdate,1318,sysdate,4959698,null,null,null,null);
128073:
128074: end if;

Line 128149: (qpr_pr_segments_s.nextval,l_instance_id,qpr_policies_s.currval,'HIGH',1,

128145: "CREATED_BY","LAST_UPDATE_DATE","LAST_UPDATED_BY",
128146: "LAST_UPDATE_LOGIN","PROGRAM_ID","PROGRAM_LOGIN_ID",
128147: "PROGRAM_APPLICATION_ID","REQUEST_ID")
128148: values
128149: (qpr_pr_segments_s.nextval,l_instance_id,qpr_policies_s.currval,'HIGH',1,
128150: sysdate,1321,sysdate,1318,4959719,null,null,null,null);
128151:
128152: Insert into qpr_pr_segments_tl
128153: ("PR_SEGMENT_ID","LANGUAGE","SOURCE_LANG",

Line 128159: qpr_pr_segments_s.currval,l.language_code,'US','Printers',null,

128155: "CREATED_BY","LAST_UPDATE_DATE","LAST_UPDATED_BY",
128156: "LAST_UPDATE_LOGIN","PROGRAM_ID","PROGRAM_LOGIN_ID",
128157: "PROGRAM_APPLICATION_ID","REQUEST_ID")
128158: select
128159: qpr_pr_segments_s.currval,l.language_code,'US','Printers',null,
128160: sysdate,1318,sysdate,1318,4959698,1,1,1,1
128161: from fnd_languages l where l.installed_flag in ('B','I');
128162:
128163: select qpr_pr_segments_s.currval into psg_level1_value from dual;

Line 128163: select qpr_pr_segments_s.currval into psg_level1_value from dual;

128159: qpr_pr_segments_s.currval,l.language_code,'US','Printers',null,
128160: sysdate,1318,sysdate,1318,4959698,1,1,1,1
128161: from fnd_languages l where l.installed_flag in ('B','I');
128162:
128163: select qpr_pr_segments_s.currval into psg_level1_value from dual;
128164: insert_psg_dim_value(psg_level1_value, 'Printers', l_instance_id);
128165:
128166: Insert into qpr_scopes
128167: ("SCOPE_ID","PARENT_ENTITY_TYPE","PARENT_ID",

Line 128174: (qpr_scopes_s.nextval,'PRICINGSEGMENT',qpr_pr_segments_s.currval,

128170: "CREATED_BY","CREATION_DATE","LAST_UPDATED_BY",
128171: "LAST_UPDATE_DATE","LAST_UPDATE_LOGIN","PROGRAM_ID",
128172: "PROGRAM_LOGIN_ID","PROGRAM_APPLICATION_ID","REQUEST_ID")
128173: values
128174: (qpr_scopes_s.nextval,'PRICINGSEGMENT',qpr_pr_segments_s.currval,
128175: 'PRD',4,9,'=','102','Printers',1318,
128176: sysdate,1318,sysdate,4959698,null,null,null,null);
128177:
128178: end if; -- Pr Seg Check