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_POLICIES_S

Line 127792: (qpr_policies_s.nextval,'Y',

127788: "CREATED_BY","LAST_UPDATE_DATE","LAST_UPDATED_BY",
127789: "LAST_UPDATE_LOGIN","PROGRAM_ID","PROGRAM_LOGIN_ID",
127790: "PROGRAM_APPLICATION_ID","REQUEST_ID")
127791: values
127792: (qpr_policies_s.nextval,'Y',
127793: sysdate,1318,sysdate,1012169,4274338,null,null,null,null);
127794:
127795: Insert into qpr_policies_tl
127796: ("POLICY_ID","LANGUAGE","SOURCE_LANG",

Line 127801: select qpr_policies_s.currval,l.language_code,'US','OOW - Policies',null,

127797: "NAME","DESCRIPTION","CREATION_DATE",
127798: "CREATED_BY","LAST_UPDATE_DATE","LAST_UPDATED_BY",
127799: "LAST_UPDATE_LOGIN","PROGRAM_ID","PROGRAM_LOGIN_ID",
127800: "PROGRAM_APPLICATION_ID","REQUEST_ID")
127801: select qpr_policies_s.currval,l.language_code,'US','OOW - Policies',null,
127802: sysdate,1318,sysdate,1012169,4274338,null,null,null,null
127803: from fnd_languages l where l.installed_flag in ('B','I');
127804:
127805: Insert into qpr_policy_lines

Line 127814: (qpr_policy_lines_s.nextval,qpr_policies_s.currval,'FIELD_USER',

127810: "CREATED_BY","LAST_UPDATE_DATE","LAST_UPDATED_BY",
127811: "LAST_UPDATE_LOGIN","PROGRAM_ID","PROGRAM_LOGIN_ID",
127812: "PROGRAM_APPLICATION_ID","REQUEST_ID")
127813: values
127814: (qpr_policy_lines_s.nextval,qpr_policies_s.currval,'FIELD_USER',
127815: 'ONINVOICE',null,null,'PERCENT',40,to_date('01-01-00','DD-MM-RR'),null,null,
127816: sysdate,1323,sysdate,1318,4943173,null,null,null,null);
127817:
127818: l_exist_pr_seg := 0;

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 127892: (qpr_policies_s.nextval,'Y',

127888: "CREATED_BY","LAST_UPDATE_DATE","LAST_UPDATED_BY",
127889: "LAST_UPDATE_LOGIN","PROGRAM_ID","PROGRAM_LOGIN_ID",
127890: "PROGRAM_APPLICATION_ID","REQUEST_ID")
127891: values
127892: (qpr_policies_s.nextval,'Y',
127893: sysdate,1012171,sysdate,1318,4952122,null,null,null,null);
127894:
127895: Insert into qpr_policies_tl
127896: ("POLICY_ID","LANGUAGE","SOURCE_LANG",

Line 127902: qpr_policies_s.currval,l.language_code,'US','Hi - Tech Controlled',

127898: "CREATED_BY","LAST_UPDATE_DATE","LAST_UPDATED_BY",
127899: "LAST_UPDATE_LOGIN","PROGRAM_ID","PROGRAM_LOGIN_ID",
127900: "PROGRAM_APPLICATION_ID","REQUEST_ID")
127901: select
127902: qpr_policies_s.currval,l.language_code,'US','Hi - Tech Controlled',
127903: 'Pricing Policy for Strategics Retail Customers',
127904: sysdate,1012171,sysdate,1318,4952122,null,null,null,null
127905: from fnd_languages l where l.installed_flag in ('B','I');
127906:

Line 127916: (qpr_policy_lines_s.nextval,qpr_policies_s.currval,'FIELD_USER',

127912: "CREATED_BY","LAST_UPDATE_DATE","LAST_UPDATED_BY",
127913: "LAST_UPDATE_LOGIN","PROGRAM_ID","PROGRAM_LOGIN_ID",
127914: "PROGRAM_APPLICATION_ID","REQUEST_ID")
127915: values
127916: (qpr_policy_lines_s.nextval,qpr_policies_s.currval,'FIELD_USER',
127917: 'ONINVOICE',null,null,'PERCENT',30,to_date('05-02-08','DD-MM-RR'),null,null,
127918: sysdate,1342,sysdate,1318,4956135,null,null,null,null);
127919:
127920: l_exist_pr_seg := 0;

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 127996: (qpr_policies_s.nextval,'Y',

127992: "CREATED_BY","LAST_UPDATE_DATE","LAST_UPDATED_BY",
127993: "LAST_UPDATE_LOGIN","PROGRAM_ID","PROGRAM_LOGIN_ID",
127994: "PROGRAM_APPLICATION_ID","REQUEST_ID")
127995: values
127996: (qpr_policies_s.nextval,'Y',
127997: sysdate,1318,sysdate,1318,4959698,null,null,null,null);
127998:
127999: Insert into qpr_policies_tl
128000: ("POLICY_ID","LANGUAGE","SOURCE_LANG",

Line 128006: qpr_policies_s.currval,l.language_code,'US','Pocket Margin - Computers',

128002: "CREATED_BY","LAST_UPDATE_DATE","LAST_UPDATED_BY",
128003: "LAST_UPDATE_LOGIN","PROGRAM_ID","PROGRAM_LOGIN_ID",
128004: "PROGRAM_APPLICATION_ID","REQUEST_ID")
128005: select
128006: qpr_policies_s.currval,l.language_code,'US','Pocket Margin - Computers',
128007: 'Pocket Margin - Computers',
128008: sysdate,1318,sysdate,1318,4959698,null,null,null,null
128009: from fnd_languages l where l.installed_flag in ('B','I');
128010:

Line 128020: (qpr_policy_lines_s.nextval,qpr_policies_s.currval,'FIELD_USER',

128016: "CREATED_BY","LAST_UPDATE_DATE","LAST_UPDATED_BY",
128017: "LAST_UPDATE_LOGIN","PROGRAM_ID","PROGRAM_LOGIN_ID",
128018: "PROGRAM_APPLICATION_ID","REQUEST_ID")
128019: values
128020: (qpr_policy_lines_s.nextval,qpr_policies_s.currval,'FIELD_USER',
128021: 'COST',null,null,'PERCENT',32,to_date('06-05-08','DD-MM-RR'),null,null,
128022: sysdate,1319,sysdate,1353,4959933,null,null,null,null);
128023:
128024:

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 128101: (qpr_policies_s.nextval,'Y',

128097: "CREATED_BY","LAST_UPDATE_DATE","LAST_UPDATED_BY",
128098: "LAST_UPDATE_LOGIN","PROGRAM_ID","PROGRAM_LOGIN_ID",
128099: "PROGRAM_APPLICATION_ID","REQUEST_ID")
128100: values
128101: (qpr_policies_s.nextval,'Y',
128102: sysdate,1318,sysdate,1318,4959698,null,null,null,null);
128103:
128104: Insert into qpr_policies_tl
128105: ("POLICY_ID","LANGUAGE","SOURCE_LANG",

Line 128111: qpr_policies_s.currval,l.language_code,'US','Pocket Margin - Printers',

128107: "CREATED_BY","LAST_UPDATE_DATE","LAST_UPDATED_BY",
128108: "LAST_UPDATE_LOGIN","PROGRAM_ID","PROGRAM_LOGIN_ID",
128109: "PROGRAM_APPLICATION_ID","REQUEST_ID")
128110: select
128111: qpr_policies_s.currval,l.language_code,'US','Pocket Margin - Printers',
128112: 'Pocket Margin - Printers',
128113: sysdate,1318,sysdate,1318,4959698,null,null,null,null
128114: from fnd_languages l where l.installed_flag in ('B','I');
128115:

Line 128125: (qpr_policy_lines_s.nextval,qpr_policies_s.currval,'FIELD_USER',

128121: "CREATED_BY","LAST_UPDATE_DATE","LAST_UPDATED_BY",
128122: "LAST_UPDATE_LOGIN","PROGRAM_ID","PROGRAM_LOGIN_ID",
128123: "PROGRAM_APPLICATION_ID","REQUEST_ID")
128124: values
128125: (qpr_policy_lines_s.nextval,qpr_policies_s.currval,'FIELD_USER',
128126: 'COST',null,null,'PERCENT',25,to_date('06-05-08','DD-MM-RR'),null,null,
128127: sysdate,1318,sysdate,1318,4959698,null,null,null,null);
128128:
128129:

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",