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 661: FROM msc_plan_organizations_v plan_org

657: LENGTH( apps1.instance_code)+2
658: FROM msc_apps_instances apps1,
659: ( SELECT distinct
660: sr_instance_id
661: FROM msc_plan_organizations_v plan_org
662: WHERE plan_org.plan_id = arg_plan_id
663: AND plan_org.organization_id = arg_org_id
664: AND plan_org.owning_sr_instance = arg_sr_instance
665: AND plan_org.sr_instance_id =

Line 1094: FROM msc_plan_organizations_v plan_org

1090: LENGTH( apps1.instance_code)+2
1091: FROM msc_apps_instances apps1,
1092: ( SELECT distinct
1093: sr_instance_id
1094: FROM msc_plan_organizations_v plan_org
1095: WHERE plan_org.plan_id = arg_plan_id
1096: AND plan_org.organization_id = arg_org_id
1097: AND plan_org.owning_sr_instance = arg_sr_instance
1098: AND plan_org.sr_instance_id =

Line 2834: ' msc_plan_organizations_v orgs ' ||

2830: ' msc_trading_partners mp2,' ||
2831: ' msc_system_items msi, ' ||
2832: ' msc_system_items msi1,' ||
2833: ' msc_supplies s, ' ||
2834: ' msc_plan_organizations_v orgs ' ||
2835: ' WHERE mpp.organization_id (+)= s.organization_id ' ||
2836: ' AND mpp.project_id (+)= nvl(s.implement_project_id,-23453) ' ||
2837: ' AND mpp.plan_id (+)= s.plan_id ' ||
2838: ' AND mpp.sr_instance_id(+)= s.sr_instance_id ' ||

Line 2966: ' msc_plan_organizations_v orgs ' ||

2962: ' msc_system_items msi, ' ||
2963: ' msc_system_items msi1,' ||
2964: ' msc_supplies s,' ||
2965: ' msc_demands d,' ||
2966: ' msc_plan_organizations_v orgs ' ||
2967: ' WHERE mpp.organization_id (+)= s.organization_id ' ||
2968: ' AND mpp.project_id (+)= nvl(s.implement_project_id,-23453) ' ||
2969: ' AND mpp.plan_id (+)= s.plan_id ' ||
2970: ' AND mpp.sr_instance_id(+)= s.sr_instance_id ' ||

Line 3192: 'msc_plan_organizations_v orgs '||

3188: ' msc_trading_partners mp2, ' ||
3189: 'msc_system_items msi, '||
3190: 'msc_system_items msi1,'||
3191: 'msc_part_supplies s, '||
3192: 'msc_plan_organizations_v orgs '||
3193: 'WHERE mpp.organization_id (+)= s.organization_id '||
3194: 'AND mpp.project_id (+)= nvl(s.implement_project_id,-23453) ' ||
3195: 'AND mpp.plan_id (+)= s.plan_id '||
3196: 'AND mpp.sr_instance_id(+)= s.sr_instance_id '||

Line 4361: msc_plan_organizations_v orgs,

4357: 2)),
4358: s.organization_id,
4359: s.plan_id
4360: FROM msc_supplies s,
4361: msc_plan_organizations_v orgs,
4362: msc_plan_buckets mpb,
4363: msc_system_items msi,
4364: msc_plans mp
4365: WHERE mp.plan_id = :arg_plan_id

Line 4414: msc_plan_organizations_v orgs

4410: 2 /* Details not enabled for Manual Planned orders */,
4411: s.organization_id,
4412: s.plan_id
4413: FROM msc_supplies s,
4414: msc_plan_organizations_v orgs
4415: WHERE s.release_errors is NULL
4416: AND nvl(s.cfm_routing_flag,0) = 3
4417: AND s.implement_quantity > 0
4418: AND s.organization_id = orgs.planned_organization

Line 5341: msc_plan_organizations_v orgs,

5337: s.organization_id,
5338: s.plan_id
5339: FROM msc_plans mp,
5340: msc_supplies s,
5341: msc_plan_organizations_v orgs,
5342: msc_plan_buckets mpb
5343: WHERE mp.plan_id = :arg_plan_id
5344: AND s.release_errors is NULL
5345: AND s.implement_quantity > 0

Line 5539: msc_plan_organizations_v orgs

5535: FROM msc_trading_partners tp,
5536: msc_parameters param,
5537: msc_system_items msi,
5538: msc_supplies s,
5539: msc_plan_organizations_v orgs
5540: WHERE tp.sr_tp_id= msi.organization_id
5541: AND tp.sr_instance_id= msi.sr_instance_id
5542: AND tp.partner_type=3
5543: AND param.organization_id = msi.organization_id

Line 6398: msc_plan_organizations_v orgs,

6394: NVL(s.implement_quantity, 0)
6395: -- NVL(s.qty_scrapped, 0),
6396: -- NVL(s.qty_completed, 0)
6397: FROM msc_supplies s,
6398: msc_plan_organizations_v orgs,
6399: msc_plan_buckets mpb,
6400: msc_system_items msi,
6401: msc_plans mp
6402: WHERE mp.plan_id = :arg_plan_id

Line 6456: msc_plan_organizations_v orgs

6452: NVL(s.implement_quantity, 0)
6453: -- NVL(s.qty_scrapped, 0),
6454: -- NVL(s.qty_completed, 0)
6455: FROM msc_supplies s,
6456: msc_plan_organizations_v orgs
6457: WHERE s.release_errors is NULL
6458: AND s.implement_quantity > 0
6459: AND s.organization_id = orgs.planned_organization
6460: AND s.sr_instance_id = orgs.sr_instance_id

Line 8012: msc_plan_organizations_v orgs,

8008: NVL(s.qty_scrapped, 0),
8009: NVL(s.qty_completed, 0)
8010: FROM msc_supplies s,
8011: msc_plans mp,
8012: msc_plan_organizations_v orgs,
8013: msc_plan_buckets mpb
8014: WHERE s.release_errors is NULL
8015: AND s.implement_quantity > 0
8016: AND s.organization_id = orgs.planned_organization

Line 8275: msc_plan_organizations_v orgs,

8271: FROM msc_trading_partners tp,
8272: msc_parameters param,
8273: msc_system_items msi,
8274: msc_supplies s,
8275: msc_plan_organizations_v orgs,
8276: msc_boms mb
8277: WHERE tp.sr_tp_id= msi.organization_id
8278: AND tp.sr_instance_id= msi.sr_instance_id
8279: AND tp.partner_type=3

Line 9413: msc_plan_organizations_v orgs

9409: msc_parameters param,
9410: msc_system_items msi,
9411: msc_process_effectivity mpe,
9412: msc_supplies s,
9413: msc_plan_organizations_v orgs
9414: WHERE tp.sr_tp_id= msi.organization_id
9415: AND tp.sr_instance_id= msi.sr_instance_id
9416: AND tp.partner_type=3
9417: AND param.organization_id = msi.organization_id

Line 9658: msc_plan_organizations_v orgs

9654: msc_system_items msi,
9655: msc_system_items msi1,
9656: msc_supplies s,
9657: msc_item_suppliers mis,
9658: msc_plan_organizations_v orgs
9659: WHERE supplier.tp_id(+)=
9660: nvl(s.implement_supplier_id, s.source_supplier_id)
9661: AND supplier.partner_type(+)=1
9662: AND supplier.sr_instance_id(+)= s.sr_instance_id

Line 9804: msc_plan_organizations_v orgs

9800: msc_system_items msi,
9801: msc_system_items msi1,
9802: msc_item_suppliers mis,
9803: msc_supplies s,
9804: msc_plan_organizations_v orgs
9805: WHERE supplier.tp_id(+)=
9806: nvl(s.implement_supplier_id, s.source_supplier_id)
9807: AND supplier.partner_type(+)=1
9808: AND supplier.sr_instance_id(+)= s.sr_instance_id

Line 9949: msc_plan_organizations_v orgs

9945: msc_system_items msi,
9946: msc_system_items msi1,
9947: msc_item_suppliers mis,
9948: msc_supplies s,
9949: msc_plan_organizations_v orgs
9950: WHERE supplier.tp_id(+)=
9951: nvl(s.implement_supplier_id, s.source_supplier_id)
9952: AND supplier.partner_type(+)=1
9953: AND supplier.sr_instance_id(+)= s.sr_instance_id

Line 10103: msc_plan_organizations_v orgs

10099: msc_trading_partners mp,
10100: msc_system_items msi,
10101: msc_supplies s,
10102: msc_apps_instances mai, -- IR/ISO resch Proj
10103: msc_plan_organizations_v orgs
10104: WHERE --cal1.sr_instance_id= mp.sr_instance_id
10105: --AND cal1.calendar_code = mp.calendar_code
10106: --AND cal1.exception_set_id = mp.calendar_exception_set_id
10107: --AND cal1.calendar_date = trunc(s.implement_date)

Line 10161: msc_plan_organizations_v orgs

10157: --msc_calendar_dates cal2,
10158: msc_trading_partners mp,
10159: msc_system_items msi,
10160: msc_supplies s,
10161: msc_plan_organizations_v orgs
10162: WHERE --cal1.sr_instance_id= mp.sr_instance_id
10163: --AND cal1.calendar_code = mp.calendar_code
10164: -- AND cal1.exception_set_id = mp.calendar_exception_set_id
10165: -- AND cal1.calendar_date = trunc(s.implement_date)

Line 10270: msc_plan_organizations_v orgs

10266: --msc_calendar_dates cal2,
10267: msc_trading_partners mp,
10268: msc_system_items msi,
10269: msc_supplies s,
10270: msc_plan_organizations_v orgs
10271: WHERE --cal1.sr_instance_id = mp.sr_instance_id
10272: --AND cal1.calendar_code = mp.calendar_code
10273: --AND cal1.exception_set_id = mp.calendar_exception_set_id
10274: --AND cal1.calendar_date = trunc(NVL(s.implement_date,s.new_schedule_date))

Line 10458: msc_plan_organizations_v orgs,

10454: NVL(s.wip_start_quantity, 0),
10455: NVL(s.new_order_quantity, 0),
10456: NVL(s.implement_quantity, 0)
10457: FROM msc_supplies s,
10458: msc_plan_organizations_v orgs,
10459: msc_plan_buckets mpb,
10460: msc_system_items msi,
10461: msc_plans mp,
10462: msc_item_attributes msa

Line 10808: msc_plan_organizations_v orgs,

10804: NVL(s.qty_scrapped, 0),
10805: NVL(s.qty_completed, 0)
10806: FROM msc_supplies s,
10807: msc_plans mp,
10808: msc_plan_organizations_v orgs,
10809: msc_plan_buckets mpb
10810: WHERE s.release_errors is NULL
10811: AND s.implement_quantity > 0
10812: AND s.organization_id = orgs.planned_organization

Line 11046: msc_plan_organizations_v orgs

11042: FROM msc_trading_partners tp,
11043: msc_parameters param,
11044: msc_system_items msi,
11045: msc_supplies s,
11046: msc_plan_organizations_v orgs
11047: WHERE tp.sr_tp_id= msi.organization_id
11048: AND tp.sr_instance_id= msi.sr_instance_id
11049: AND tp.partner_type=3
11050: AND param.organization_id = msi.organization_id

Line 12137: msc_plan_organizations_v orgs,

12133: NVL(s.qty_scrapped, 0),
12134: NVL(s.qty_completed, 0)
12135: FROM msc_supplies s,
12136: msc_plans mp,
12137: msc_plan_organizations_v orgs,
12138: msc_plan_buckets mpb
12139: WHERE s.release_errors is NULL
12140: AND s.implement_quantity > 0
12141: AND s.organization_id = orgs.planned_organization

Line 12375: msc_plan_organizations_v orgs

12371: FROM msc_trading_partners tp,
12372: msc_parameters param,
12373: msc_system_items msi,
12374: msc_supplies s,
12375: msc_plan_organizations_v orgs
12376: WHERE tp.sr_tp_id= msi.organization_id
12377: AND tp.sr_instance_id= msi.sr_instance_id
12378: AND tp.partner_type=3
12379: AND param.organization_id = msi.organization_id