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_SYSTEM_ITEMS

Line 2296: ' msc_system_items msi, ' ||

2292: ' nvl(s.implement_ship_method,s.ship_method) ' ||
2293: ' FROM msc_projects mpp, '||
2294: ' msc_trading_partners mp, ' ||
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 ' ||

Line 2297: ' msc_system_items msi1,' ||

2293: ' FROM msc_projects mpp, '||
2294: ' msc_trading_partners mp, ' ||
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) ' ||

Line 2426: ' msc_system_items msi, ' ||

2422: ' nvl(s.implement_ship_method,s.ship_method) ' ||
2423: ' FROM msc_projects mpp, '||
2424: ' msc_trading_partners mp, ' ||
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 ' ||

Line 2427: ' msc_system_items msi1,' ||

2423: ' FROM msc_projects mpp, '||
2424: ' msc_trading_partners mp, ' ||
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 ' ||

Line 2649: 'msc_system_items msi, '||

2645: ' nvl(s.implement_ship_method,s.ship_method) ' ||
2646: ' FROM msc_projects mpp, ' ||
2647: ' msc_trading_partners mp, ' ||
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 '||

Line 2650: 'msc_system_items msi1,'||

2646: ' FROM msc_projects mpp, ' ||
2647: ' msc_trading_partners mp, ' ||
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) ' ||

Line 2867: msc_system_items msi1,

2863: s.implement_source_org_id
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,

Line 3209: msc_system_items msi1

3205: msc_part_demands d1,
3206: mfg0 mfg1,
3207: msc_part_supplies s2,
3208: msc_part_demands d2,
3209: msc_system_items msi1
3210: WHERE
3211: k.release_errors IS NULL
3212: AND (k.releasable = ' || RELEASABLE || ' or k.releasable is null )
3213: AND k.sr_instance_id = '||p_arg_org_instance|| '

Line 3461: msc_system_items msi,

3457: s2.new_order_quantity defective_part_quantity
3458: FROM msc_supplies s,
3459: Msc_supplies s1,
3460: Msc_supplies s2 ,
3461: msc_system_items msi,
3462: msc_system_items msi1,
3463: msc_trading_partners mtp,
3464: msc_trading_partners mtp1,
3465: msc_demands d ,

Line 3462: msc_system_items msi1,

3458: FROM msc_supplies s,
3459: Msc_supplies s1,
3460: Msc_supplies s2 ,
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,

Line 3614: msc_system_items msi,

3610: msi1.sr_inventory_item_id defective_item_id,
3611: s2.new_order_quantity defective_part_quantity
3612: FROM
3613: msc_supplies k,
3614: msc_system_items msi,
3615: msc_part_supplies s,
3616: msc_part_demands d,
3617: Msc_part_supplies s1,
3618: msc_trading_partners mtp,

Line 3623: msc_system_items msi1,

3619: msc_trading_partners mtp1,
3620: msc_part_demands d1,
3621: Msc_part_supplies s2,
3622: msc_part_demands d2,
3623: msc_system_items msi1,
3624: (select distinct transaction_id,plan_id,organization_id ,sr_instance_id ,demand_id
3625: from msc_part_pegging
3626: where sr_instance_id = '||p_arg_org_instance||'
3627: and plan_id ='||p_arg_plan_id||'

Line 3814: msc_system_items msi,

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
3817: AND s.release_errors is NULL
3818: AND nvl(s.cfm_routing_flag,0) = 3

Line 4056: msc_system_items msi,

4052: , s.schedule_priority
4053: , nvl(s.requested_completion_date, s.need_by_date)
4054: FROM msc_trading_partners tp,
4055: msc_parameters param,
4056: msc_system_items msi,
4057: msc_process_effectivity mpe,
4058: msc_supplies s
4059: WHERE tp.sr_tp_id= msi.organization_id
4060: AND tp.sr_instance_id= msi.sr_instance_id

Line 4291: msc_system_items msi

4287: msc_resource_requirements res,
4288: msc_apps_instances ins,
4289: msc_parameters param,
4290: msc_department_resources mdr,
4291: msc_system_items msi
4292: Where res.plan_id = s.plan_id
4293: AND res.sr_instance_id = s.sr_instance_id
4294: AND s.transaction_id = res.supply_id
4295: AND res.parent_id = 2

Line 4374: msc_system_items icomp,

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,
4378: msc_parameters param

Line 4375: msc_system_items icomp1,

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,
4378: msc_parameters param
4379: Where /* not exists (select 'x'

Line 4376: msc_system_items icomp2,

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,
4378: msc_parameters param
4379: Where /* not exists (select 'x'
4380: from msc_exception_details excp

Line 4981: msc_system_items msi,

4977: , s.schedule_priority
4978: , s.requested_completion_date
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

Line 5229: msc_system_items msi

5225: msc_resource_requirements res,
5226: msc_apps_instances ins,
5227: msc_parameters param,
5228: msc_department_resources mdr,
5229: msc_system_items msi
5230: Where res.plan_id = s.plan_id
5231: AND res.sr_instance_id = s.sr_instance_id
5232: AND s.transaction_id = res.supply_id
5233: AND res.parent_id = 2

Line 5314: msc_system_items icomp,

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,
5318: msc_parameters param

Line 5315: msc_system_items icomp1,

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,
5318: msc_parameters param
5319: Where /* not exists (select 'x'

Line 5316: msc_system_items icomp2,

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,
5318: msc_parameters param
5319: Where /* not exists (select 'x'
5320: from msc_exception_details excp

Line 5811: msc_system_items msi,

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
5814: AND s.release_errors is NULL
5815: AND s.implement_quantity > 0

Line 6084: msc_system_items msi,

6080: , s.schedule_priority
6081: , nvl(s.requested_completion_date, s.need_by_date)
6082: FROM msc_trading_partners tp,
6083: msc_parameters param,
6084: msc_system_items msi,
6085: msc_process_effectivity mpe,
6086: msc_supplies s
6087: WHERE tp.sr_tp_id= msi.organization_id
6088: AND tp.sr_instance_id= msi.sr_instance_id

Line 6215: msc_system_items msi,

6211: s.sr_instance_id
6212: FROM msc_trading_partners tp,
6213: msc_resource_requirements resreq,
6214: msc_parameters param,
6215: msc_system_items msi,
6216: msc_supplies s
6217: WHERE tp.sr_tp_id= msi.organization_id
6218: AND tp.sr_instance_id= msi.sr_instance_id
6219: AND tp.partner_type=3

Line 6377: msc_system_items msi,

6373: , resreq.resource_seq_num
6374: FROM msc_trading_partners tp,
6375: msc_resource_requirements resreq,
6376: msc_parameters param,
6377: msc_system_items msi,
6378: msc_supplies s,
6379: msc_department_resources mdr
6380: WHERE tp.sr_tp_id= msi.organization_id
6381: AND tp.sr_instance_id= msi.sr_instance_id

Line 6495: msc_system_items icomp,

6491: -- md.operation_seq_id,
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

Line 6498: msc_system_items msi,

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 /*
6501: ( md.SUBST_ITEM_FLAG <> 1
6502: OR md.SUBST_ITEM_FLAG IS NULL) */

Line 6600: msc_system_items icomp,

6596: TO_CHAR(NULL),
6597: nvl(s.implement_uom_code,msi.uom_code),
6598: s.sr_instance_id
6599: FROM msc_trading_partners tp,
6600: msc_system_items icomp,
6601: msc_supplies co,
6602: msc_parameters param,
6603: msc_system_items msi,
6604: msc_supplies s

Line 6603: msc_system_items msi,

6599: FROM msc_trading_partners tp,
6600: msc_system_items icomp,
6601: msc_supplies co,
6602: msc_parameters param,
6603: msc_system_items msi,
6604: msc_supplies s
6605: WHERE /* not exists (select 'x'
6606: from msc_exception_details excp
6607: where excp.plan_id = msi.plan_id

Line 6720: msc_system_items icomp,

6716: msc_bom_components subcomp,
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

Line 6723: msc_system_items msi,

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
6726: AND tp.sr_instance_id= msi.sr_instance_id
6727: AND tp.partner_type=3

Line 6868: msc_system_items msi,

6864: resreq.parent_seq_num
6865: FROM msc_trading_partners tp,
6866: msc_resource_requirements resreq,
6867: msc_parameters param,
6868: msc_system_items msi,
6869: msc_supplies s,
6870: msc_department_resources mdr
6871: WHERE tp.sr_tp_id= msi.organization_id
6872: AND tp.sr_instance_id= msi.sr_instance_id

Line 7492: msc_system_items msi,

7488: , s.schedule_priority -- dsr
7489: , s.requested_completion_date -- dsr
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

Line 7620: msc_system_items msi,

7616: , decode(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr
7617: FROM msc_trading_partners tp,
7618: msc_resource_requirements resreq,
7619: msc_parameters param,
7620: msc_system_items msi,
7621: msc_supplies s
7622: WHERE tp.sr_tp_id= msi.organization_id
7623: AND tp.sr_instance_id= msi.sr_instance_id
7624: AND tp.partner_type=3

Line 7769: msc_system_items msi,

7765: , resreq.resource_seq_num
7766: FROM msc_trading_partners tp,
7767: msc_resource_requirements resreq,
7768: msc_parameters param,
7769: msc_system_items msi,
7770: msc_supplies s
7771: WHERE tp.sr_tp_id= msi.organization_id
7772: AND tp.sr_instance_id= msi.sr_instance_id
7773: AND tp.partner_type=3

Line 7873: msc_system_items icomp,

7869: nvl(s.implement_uom_code, msi.uom_code),
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

Line 7876: msc_system_items msi,

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 /*
7879: ( md.SUBST_ITEM_FLAG <> 1
7880: OR md.SUBST_ITEM_FLAG IS NULL) */

Line 7987: msc_system_items icomp,

7983: nvl(s.implement_uom_code, msi.uom_code),
7984: s.disposition_id
7985: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
7986: FROM msc_trading_partners tp,
7987: msc_system_items icomp,
7988: msc_supplies co,
7989: msc_parameters param,
7990: msc_system_items msi,
7991: msc_supplies s

Line 7990: msc_system_items msi,

7986: FROM msc_trading_partners tp,
7987: msc_system_items icomp,
7988: msc_supplies co,
7989: msc_parameters param,
7990: msc_system_items msi,
7991: msc_supplies s
7992: WHERE /*not exists (select 'x'
7993: from msc_exception_details excp
7994: where excp.plan_id = msi.plan_id

Line 8117: msc_system_items msi,

8113: ,resreq.parent_seq_num
8114: FROM msc_trading_partners tp,
8115: msc_resource_requirements resreq,
8116: msc_parameters param,
8117: msc_system_items msi,
8118: msc_supplies s
8119: WHERE tp.sr_tp_id= msi.organization_id
8120: AND tp.sr_instance_id= msi.sr_instance_id
8121: AND tp.partner_type=3

Line 8567: msc_system_items msi,

8563: nvl(s.implement_uom_code,msi.uom_code),
8564: s.sr_instance_id
8565: FROM msc_trading_partners tp,
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

Line 8794: msc_system_items msi,

8790: msc_tp_id_lid supplier,
8791: msc_trading_partner_sites mtps,
8792: msc_trading_partners mp, -- mtl_parameters mp,
8793: msc_trading_partners mp1,
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

Line 8795: msc_system_items msi1,

8791: msc_trading_partner_sites mtps,
8792: msc_trading_partners mp, -- mtl_parameters mp,
8793: msc_trading_partners mp1,
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(+)=

Line 8937: msc_system_items msi,

8933: msc_tp_id_lid supplier,
8934: msc_trading_partner_sites mtps,
8935: msc_trading_partners mp, -- mtl_parameters mp,
8936: msc_trading_partners mp1,
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

Line 8938: msc_system_items msi1,

8934: msc_trading_partner_sites mtps,
8935: msc_trading_partners mp, -- mtl_parameters mp,
8936: msc_trading_partners mp1,
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(+)=

Line 9079: msc_system_items msi,

9075: msc_tp_id_lid supplier,
9076: msc_trading_partner_sites mtps,
9077: msc_trading_partners mp, -- mtl_parameters mp,
9078: msc_trading_partners mp1,
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

Line 9080: msc_system_items msi1,

9076: msc_trading_partner_sites mtps,
9077: msc_trading_partners mp, -- mtl_parameters mp,
9078: msc_trading_partners mp1,
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(+)=

Line 9231: msc_system_items msi,

9227: g_batch_id
9228: FROM --msc_calendar_dates cal1,
9229: --msc_calendar_dates cal2,
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

Line 9290: msc_system_items msi,

9286: g_batch_id
9287: FROM --msc_calendar_dates cal1,
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

Line 9399: msc_system_items msi,

9395: lv_po_number
9396: FROM --msc_calendar_dates cal1,
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