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_PLAN_ORGANIZATIONS_V

Line 532: FROM msc_plan_organizations_v plan_org

528: LENGTH( apps.instance_code)+2
529: FROM msc_apps_instances apps,
530: ( SELECT distinct
531: sr_instance_id
532: FROM msc_plan_organizations_v plan_org
533: WHERE plan_org.plan_id = arg_plan_id
534: AND plan_org.organization_id = arg_org_id
535: AND plan_org.owning_sr_instance = arg_sr_instance
536: AND plan_org.sr_instance_id =

Line 903: FROM msc_plan_organizations_v plan_org

899: LENGTH( apps.instance_code)+2
900: FROM msc_apps_instances apps,
901: ( SELECT distinct
902: sr_instance_id
903: FROM msc_plan_organizations_v plan_org
904: WHERE plan_org.plan_id = arg_plan_id
905: AND plan_org.organization_id = arg_org_id
906: AND plan_org.owning_sr_instance = arg_sr_instance
907: AND plan_org.sr_instance_id =

Line 2299: ' msc_plan_organizations_v orgs ' ||

2295: ' msc_trading_partners mp2,' ||
2296: ' msc_system_items msi, ' ||
2297: ' msc_system_items msi1,' ||
2298: ' msc_supplies s, ' ||
2299: ' msc_plan_organizations_v orgs ' ||
2300: ' WHERE mpp.organization_id (+)= s.organization_id ' ||
2301: ' AND mpp.project_id (+)= nvl(s.implement_project_id,-23453) ' ||
2302: ' AND mpp.plan_id (+)= s.plan_id ' ||
2303: ' AND mpp.sr_instance_id(+)= s.sr_instance_id ' ||

Line 2430: ' msc_plan_organizations_v orgs ' ||

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 ' ||
2434: ' AND mpp.sr_instance_id(+)= s.sr_instance_id ' ||

Line 2652: 'msc_plan_organizations_v orgs '||

2648: ' msc_trading_partners mp2, ' ||
2649: 'msc_system_items msi, '||
2650: 'msc_system_items msi1,'||
2651: 'msc_part_supplies s, '||
2652: 'msc_plan_organizations_v orgs '||
2653: 'WHERE mpp.organization_id (+)= s.organization_id '||
2654: 'AND mpp.project_id (+)= nvl(s.implement_project_id,-23453) ' ||
2655: 'AND mpp.plan_id (+)= s.plan_id '||
2656: 'AND mpp.sr_instance_id(+)= s.sr_instance_id '||

Line 3812: msc_plan_organizations_v orgs,

3808: 2)),
3809: s.organization_id,
3810: s.plan_id
3811: FROM msc_supplies s,
3812: msc_plan_organizations_v orgs,
3813: msc_plan_buckets mpb,
3814: msc_system_items msi,
3815: msc_plans mp
3816: WHERE mp.plan_id = :arg_plan_id

Line 3865: msc_plan_organizations_v orgs

3861: 2 /* Details not enabled for Manual Planned orders */,
3862: s.organization_id,
3863: s.plan_id
3864: FROM msc_supplies s,
3865: msc_plan_organizations_v orgs
3866: WHERE s.release_errors is NULL
3867: AND nvl(s.cfm_routing_flag,0) = 3
3868: AND s.implement_quantity > 0
3869: AND s.organization_id = orgs.planned_organization

Line 4792: msc_plan_organizations_v orgs,

4788: s.organization_id,
4789: s.plan_id
4790: FROM msc_plans mp,
4791: msc_supplies s,
4792: msc_plan_organizations_v orgs,
4793: msc_plan_buckets mpb
4794: WHERE mp.plan_id = :arg_plan_id
4795: AND s.release_errors is NULL
4796: AND s.implement_quantity > 0

Line 4983: msc_plan_organizations_v orgs

4979: FROM msc_trading_partners tp,
4980: msc_parameters param,
4981: msc_system_items msi,
4982: msc_supplies s,
4983: msc_plan_organizations_v orgs
4984: WHERE tp.sr_tp_id= msi.organization_id
4985: AND tp.sr_instance_id= msi.sr_instance_id
4986: AND tp.partner_type=3
4987: AND param.organization_id = msi.organization_id

Line 5809: msc_plan_organizations_v orgs,

5805: s.organization_id,
5806: s.plan_id,
5807: decode( ' || l_apps_ver ||' ,4,msi.rounding_control_type,3,msi.rounding_control_type,2)
5808: FROM msc_supplies s,
5809: msc_plan_organizations_v orgs,
5810: msc_plan_buckets mpb,
5811: msc_system_items msi,
5812: msc_plans mp
5813: WHERE mp.plan_id = :arg_plan_id

Line 5862: msc_plan_organizations_v orgs

5858: s.organization_id,
5859: s.plan_id,
5860: 2 /* setting rounding control to 2 ,since details are not released and this flag is used in details*/
5861: FROM msc_supplies s,
5862: msc_plan_organizations_v orgs
5863: WHERE s.release_errors is NULL
5864: AND s.implement_quantity > 0
5865: AND s.organization_id = orgs.planned_organization
5866: AND s.sr_instance_id = orgs.sr_instance_id

Line 7302: msc_plan_organizations_v orgs,

7298: s.organization_id,
7299: s.plan_id
7300: FROM msc_supplies s,
7301: msc_plans mp,
7302: msc_plan_organizations_v orgs,
7303: msc_plan_buckets mpb
7304: WHERE s.release_errors is NULL
7305: AND s.implement_quantity > 0
7306: AND s.organization_id = orgs.planned_organization

Line 7494: msc_plan_organizations_v orgs

7490: FROM msc_trading_partners tp,
7491: msc_parameters param,
7492: msc_system_items msi,
7493: msc_supplies s,
7494: msc_plan_organizations_v orgs
7495: WHERE tp.sr_tp_id= msi.organization_id
7496: AND tp.sr_instance_id= msi.sr_instance_id
7497: AND tp.partner_type=3
7498: AND param.organization_id = msi.organization_id

Line 8570: msc_plan_organizations_v orgs

8566: msc_parameters param,
8567: msc_system_items msi,
8568: msc_process_effectivity mpe,
8569: msc_supplies s,
8570: msc_plan_organizations_v orgs
8571: WHERE tp.sr_tp_id= msi.organization_id
8572: AND tp.sr_instance_id= msi.sr_instance_id
8573: AND tp.partner_type=3
8574: AND param.organization_id = msi.organization_id

Line 8798: msc_plan_organizations_v orgs

8794: msc_system_items msi,
8795: msc_system_items msi1,
8796: msc_supplies s,
8797: msc_item_suppliers mis,
8798: msc_plan_organizations_v orgs
8799: WHERE supplier.tp_id(+)=
8800: nvl(s.implement_supplier_id, s.source_supplier_id)
8801: AND supplier.partner_type(+)=1
8802: AND supplier.sr_instance_id(+)= s.sr_instance_id

Line 8941: msc_plan_organizations_v orgs

8937: msc_system_items msi,
8938: msc_system_items msi1,
8939: msc_item_suppliers mis,
8940: msc_supplies s,
8941: msc_plan_organizations_v orgs
8942: WHERE supplier.tp_id(+)=
8943: nvl(s.implement_supplier_id, s.source_supplier_id)
8944: AND supplier.partner_type(+)=1
8945: AND supplier.sr_instance_id(+)= s.sr_instance_id

Line 9083: msc_plan_organizations_v orgs

9079: msc_system_items msi,
9080: msc_system_items msi1,
9081: msc_item_suppliers mis,
9082: msc_supplies s,
9083: msc_plan_organizations_v orgs
9084: WHERE supplier.tp_id(+)=
9085: nvl(s.implement_supplier_id, s.source_supplier_id)
9086: AND supplier.partner_type(+)=1
9087: AND supplier.sr_instance_id(+)= s.sr_instance_id

Line 9234: msc_plan_organizations_v orgs

9230: msc_trading_partners mp,
9231: msc_system_items msi,
9232: msc_supplies s,
9233: msc_apps_instances mai, -- IR/ISO resch Proj
9234: msc_plan_organizations_v orgs
9235: WHERE --cal1.sr_instance_id= mp.sr_instance_id
9236: --AND cal1.calendar_code = mp.calendar_code
9237: --AND cal1.exception_set_id = mp.calendar_exception_set_id
9238: --AND cal1.calendar_date = trunc(s.implement_date)

Line 9292: msc_plan_organizations_v orgs

9288: --msc_calendar_dates cal2,
9289: msc_trading_partners mp,
9290: msc_system_items msi,
9291: msc_supplies s,
9292: msc_plan_organizations_v orgs
9293: WHERE --cal1.sr_instance_id= mp.sr_instance_id
9294: --AND cal1.calendar_code = mp.calendar_code
9295: -- AND cal1.exception_set_id = mp.calendar_exception_set_id
9296: -- AND cal1.calendar_date = trunc(s.implement_date)

Line 9401: msc_plan_organizations_v orgs

9397: --msc_calendar_dates cal2,
9398: msc_trading_partners mp,
9399: msc_system_items msi,
9400: msc_supplies s,
9401: msc_plan_organizations_v orgs
9402: WHERE --cal1.sr_instance_id = mp.sr_instance_id
9403: --AND cal1.calendar_code = mp.calendar_code
9404: --AND cal1.exception_set_id = mp.calendar_exception_set_id
9405: --AND cal1.calendar_date = trunc(NVL(s.implement_date,s.new_schedule_date))