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 MSC_DEMANDS

Line 2429: ' msc_demands d,' ||

2425: ' msc_trading_partners mp2,' ||
2426: ' msc_system_items msi, ' ||
2427: ' msc_system_items msi1,' ||
2428: ' msc_supplies s,' ||
2429: ' msc_demands d,' ||
2430: ' msc_plan_organizations_v orgs ' ||
2431: ' WHERE mpp.organization_id (+)= s.organization_id ' ||
2432: ' AND mpp.project_id (+)= nvl(s.implement_project_id,-23453) ' ||
2433: ' AND mpp.plan_id (+)= s.plan_id ' ||

Line 2868: msc_demands d,

2864: FROM msc_supplies s,
2865: msc_supplies s1,
2866: msc_supplies s2,
2867: msc_system_items msi1,
2868: msc_demands d,
2869: msc_demands d1,
2870: msc_demands d2,
2871: MFG0 mfg,
2872: mfg0 mfg1

Line 2869: msc_demands d1,

2865: msc_supplies s1,
2866: msc_supplies s2,
2867: msc_system_items msi1,
2868: msc_demands d,
2869: msc_demands d1,
2870: msc_demands d2,
2871: MFG0 mfg,
2872: mfg0 mfg1
2873: WHERE s.release_errors IS NULL

Line 2870: msc_demands d2,

2866: msc_supplies s2,
2867: msc_system_items msi1,
2868: msc_demands d,
2869: msc_demands d1,
2870: msc_demands d2,
2871: MFG0 mfg,
2872: mfg0 mfg1
2873: WHERE s.release_errors IS NULL
2874: AND s.sr_instance_id = '||p_arg_org_instance||

Line 3465: msc_demands d ,

3461: msc_system_items msi,
3462: msc_system_items msi1,
3463: msc_trading_partners mtp,
3464: msc_trading_partners mtp1,
3465: msc_demands d ,
3466: msc_demands d1,
3467: msc_demands d2,
3468: ( select distinct transaction_id,plan_id,organization_id ,sr_instance_id ,demand_id
3469: from msc_full_pegging

Line 3466: msc_demands d1,

3462: msc_system_items msi1,
3463: msc_trading_partners mtp,
3464: msc_trading_partners mtp1,
3465: msc_demands d ,
3466: msc_demands d1,
3467: msc_demands d2,
3468: ( select distinct transaction_id,plan_id,organization_id ,sr_instance_id ,demand_id
3469: from msc_full_pegging
3470: where sr_instance_id = '||p_arg_org_instance||'

Line 3467: msc_demands d2,

3463: msc_trading_partners mtp,
3464: msc_trading_partners mtp1,
3465: msc_demands d ,
3466: msc_demands d1,
3467: msc_demands d2,
3468: ( select distinct transaction_id,plan_id,organization_id ,sr_instance_id ,demand_id
3469: from msc_full_pegging
3470: where sr_instance_id = '||p_arg_org_instance||'
3471: and plan_id ='||p_arg_plan_id||'

Line 4373: msc_demands md,

4369: md.USING_REQUIREMENT_QUANTITY,
4370: 3,
4371: s.sr_instance_id
4372: From msc_supplies s,
4373: msc_demands md,
4374: msc_system_items icomp,
4375: msc_system_items icomp1,
4376: msc_system_items icomp2,
4377: msc_apps_instances ins,

Line 5313: msc_demands md,

5309: md.USING_REQUIREMENT_QUANTITY,
5310: 3,
5311: s.sr_instance_id
5312: From msc_supplies s,
5313: msc_demands md,
5314: msc_system_items icomp,
5315: msc_system_items icomp1,
5316: msc_system_items icomp2,
5317: msc_apps_instances ins,

Line 6496: msc_demands md,

6492: nvl(s.implement_uom_code,msi.uom_code),
6493: s.sr_instance_id
6494: FROM msc_trading_partners tp,
6495: msc_system_items icomp,
6496: msc_demands md,
6497: msc_parameters param,
6498: msc_system_items msi,
6499: msc_supplies s
6500: WHERE /*

Line 6721: msc_demands md,

6717: msc_component_substitutes bsub,
6718: /* msc_bom_components bcomp, */
6719: msc_boms bom,
6720: msc_system_items icomp,
6721: msc_demands md,
6722: msc_parameters param,
6723: msc_system_items msi,
6724: msc_supplies s
6725: WHERE tp.sr_tp_id= msi.organization_id

Line 7874: msc_demands md,

7870: s.disposition_id
7871: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
7872: FROM msc_trading_partners tp,
7873: msc_system_items icomp,
7874: msc_demands md,
7875: msc_parameters param,
7876: msc_system_items msi,
7877: msc_supplies s
7878: WHERE /*