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.MSC_REL_PLAN_PUB dependencies on DUAL

Line 205: select nvl(lv_total,0) into lv_total from dual;

201: and NOT (mbc.usage_quantity < 0 and mbc.component_type <> 10)
202: and coprod.order_type = 17
203: and coprod.disposition_id = disp_id;
204:
205: select nvl(lv_total,0) into lv_total from dual;
206:
207: return lv_total;
208:
209: EXCEPTION

Line 755: FROM DUAL;

751:
752: SELECT
753: DECODE(NVL(fnd_profile.value('MSC_RELEASED_BY_USER_ONLY') ,'N'), 'Y',1 ,2)
754: INTO v_msc_released_only_by_user
755: FROM DUAL;
756: v_batch_id_populated := 1;
757: IF (g_batch_id = g_prev_batch_id) OR g_batch_id = -1 THEN
758: begin
759: -- populating batch_id from destination side seq.

Line 761: FROM DUAL '

757: IF (g_batch_id = g_prev_batch_id) OR g_batch_id = -1 THEN
758: begin
759: -- populating batch_id from destination side seq.
760: Execute immediate 'select mrp_workbench_query_s.nextval
761: FROM DUAL '
762: into MSC_Rel_Plan_PUB.g_batch_id;
763: v_batch_id_populated := 2;
764: exception when others then
765: fnd_file.put_line(FND_FILE.LOG, sqlerrm);

Line 778: FROM dual;

774: INTO v_user_id,
775: l_user_name,
776: l_resp_name,
777: l_application_name
778: FROM dual;
779:
780:
781: SELECT APPLICATION_ID
782: INTO l_application_id

Line 1170: FROM DUAL;

1166:
1167: SELECT
1168: DECODE(NVL(fnd_profile.value('MSC_RELEASED_BY_USER_ONLY') ,'N'), 'Y',1 ,2)
1169: INTO v_msc_released_only_by_user
1170: FROM DUAL;
1171: v_batch_id_populated := 1;
1172: IF (g_batch_id = g_prev_batch_id) OR g_batch_id = -1 THEN
1173: begin
1174: -- populating batch_id from destination side seq.

Line 1176: FROM DUAL '

1172: IF (g_batch_id = g_prev_batch_id) OR g_batch_id = -1 THEN
1173: begin
1174: -- populating batch_id from destination side seq.
1175: Execute immediate 'select mrp_workbench_query_s.nextval
1176: FROM DUAL '
1177: into MSC_Rel_Plan_PUB.g_batch_id;
1178: v_batch_id_populated := 2;
1179: exception when others then
1180: fnd_file.put_line(FND_FILE.LOG, sqlerrm);

Line 1193: FROM dual;

1189: INTO v_user_id,
1190: l_user_name,
1191: l_resp_name,
1192: l_application_name
1193: FROM dual;
1194:
1195: -------- Release the planned order one instance by one instance.
1196:
1197: OPEN c_Instance;

Line 1632: lv_sql_stmt := ' SELECT mrp_workbench_query_s.nextval from dual'|| arg_dblink;

1628: IF ( lv_wf_load_type = IRO_LOAD OR
1629: lv_wf= SYS_NO OR
1630: lv_wf =3) AND l_apps_ver > MSC_UTIL.G_APPS115 THEN
1631:
1632: lv_sql_stmt := ' SELECT mrp_workbench_query_s.nextval from dual'|| arg_dblink;
1633: OPEN c_batch_number for lv_sql_stmt;
1634: FETCH c_batch_number INTO l_batch_number3;
1635: CLOSE c_batch_number;
1636:

Line 1717: lv_sql_stmt := ' SELECT mrp_workbench_query_s.nextval from dual'|| arg_dblink;

1713: IF (lv_wf_load_type = ERO_LOAD OR
1714: lv_wf= SYS_NO OR
1715: lv_wf =3) AND l_apps_ver > MSC_UTIL.G_APPS115 THEN
1716:
1717: lv_sql_stmt := ' SELECT mrp_workbench_query_s.nextval from dual'|| arg_dblink;
1718: OPEN c_batch_number for lv_sql_stmt;
1719: FETCH c_batch_number INTO l_batch_number4;
1720: CLOSE c_batch_number;
1721:

Line 1728: --execute immediate ' SELECT mrp_workbench_query_s@arg_dblink.nextval INTO l_batch_number4 from dual'|| arg_dblink;

1724: OPEN c_plan_type(arg_plan_id);
1725: FETCH c_plan_type INTO l_plan_type;
1726: CLOSE c_plan_type;
1727:
1728: --execute immediate ' SELECT mrp_workbench_query_s@arg_dblink.nextval INTO l_batch_number4 from dual'|| arg_dblink;
1729:
1730: --SELECT msc_plans.mrp_plan_type INTO l_plan_type from MSC_PLANS
1731: --WHERE PLAN_ID = arg_plan_id ;
1732:

Line 1821: lv_sql_stmt := ' SELECT mrp_workbench_query_s.nextval from dual'|| arg_dblink;

1817: no transaction id nor lv_wf_load_type. Therefore, we need to call
1818: the POPULATE_ISO_IN_SOURCE twice. One for new iso, another for re-sche
1819: of ISO with hardcoded load_type. */
1820:
1821: lv_sql_stmt := ' SELECT mrp_workbench_query_s.nextval from dual'|| arg_dblink;
1822:
1823: OPEN c_batch_number for lv_sql_stmt;
1824: FETCH c_batch_number INTO l_batch_number1;
1825: CLOSE c_batch_number;

Line 2029: FROM DUAL;

2025: -- Timestamp for RP Release
2026: v_rp_time := 86399/86400;
2027: SELECT DECODE(NVL(fnd_profile.value('MSC_PO_DEFAULT_TIME_STAMP') ,'1'), '1','N', 'Y')
2028: INTO l_timestamp_profile_val
2029: FROM DUAL;
2030:
2031: select decode((mp.daily_material_constraints+ mp.daily_resource_constraints+
2032: mp.weekly_material_constraints+mp.weekly_resource_constraints+
2033: mp.period_material_constraints+mp.period_resource_constraints),12,

Line 4311: FROM dual;

4307:
4308: SELECT decode(nvl(FND_PROFILE.value('MSC_RELEASE_DTLS_REVDATE'),'Y'),'N',2,1),
4309: DECODE(NVL(fnd_profile.value('MSC_INFLATE_WIP') ,'N'), 'N',2 ,1)
4310: INTO lv_release_details,lv_inflate_wip
4311: FROM dual;
4312:
4313:
4314: /* we release the lot based job details, only if it doesn't use aggregate resources */
4315:

Line 6320: FROM dual;

6316:
6317: SELECT decode(nvl(FND_PROFILE.value('MSC_RELEASE_DTLS_REVDATE'),'Y'),'N',2,1),
6318: DECODE(NVL(fnd_profile.value('MSC_INFLATE_WIP') ,'N'), 'N',2 ,1)
6319: INTO lv_release_details,lv_inflate_wip
6320: FROM dual;
6321:
6322: /* we release the discrete job, only if it doesn't use aggregate resources */
6323: /* bug 1252659 fix, replace rowid by
6324: (transaction_id,sr_instance_id,plan_id) */

Line 7979: FROM DUAL;

7975: -- Bug 10399650
7976: SELECT
7977: DECODE(NVL(fnd_profile.value('MSC_EXPLODE_IN_WIP') ,'Y'), 'Y',1 ,2)
7978: INTO lv_explode_in_wip
7979: FROM DUAL;
7980: -- we release the discrete job, only if it doesn't use aggregate resources
7981: -- bug 1252659 fix, replace rowid by
7982: -- (transaction_id,sr_instance_id,plan_id)
7983: