DBA Data[Home] [Help]

APPS.MSC_REL_PLAN_PUB dependencies on MSC_SYSTEM_ITEMS

Line 2831: ' msc_system_items msi, ' ||

2827: ' nvl(s.implement_ship_method,s.ship_method) ' ||
2828: ' FROM msc_projects mpp, '||
2829: ' msc_trading_partners mp, ' ||
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 ' ||

Line 2832: ' msc_system_items msi1,' ||

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

Line 2962: ' msc_system_items msi, ' ||

2958: ' nvl(s.implement_ship_method,s.ship_method) ' ||
2959: ' FROM msc_projects mpp, '||
2960: ' msc_trading_partners mp, ' ||
2961: ' msc_trading_partners mp2,' ||
2962: ' msc_system_items msi, ' ||
2963: ' msc_system_items msi1,' ||
2964: ' msc_supplies s,' ||
2965: ' msc_demands d,' ||
2966: ' msc_plan_organizations_v orgs ' ||

Line 2963: ' msc_system_items msi1,' ||

2959: ' FROM msc_projects mpp, '||
2960: ' msc_trading_partners mp, ' ||
2961: ' msc_trading_partners mp2,' ||
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 ' ||

Line 3189: 'msc_system_items msi, '||

3185: ' nvl(s.implement_ship_method,s.ship_method) ' ||
3186: ' FROM msc_projects mpp, ' ||
3187: ' msc_trading_partners mp, ' ||
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 '||

Line 3190: 'msc_system_items msi1,'||

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

Line 3407: msc_system_items msi1,

3403: s.implement_source_org_id
3404: FROM msc_supplies s,
3405: msc_supplies s1,
3406: msc_supplies s2,
3407: msc_system_items msi1,
3408: msc_demands d,
3409: msc_demands d1,
3410: msc_demands d2,
3411: MFG0 mfg,

Line 3749: msc_system_items msi1

3745: msc_part_demands d1,
3746: mfg0 mfg1,
3747: msc_part_supplies s2,
3748: msc_part_demands d2,
3749: msc_system_items msi1
3750: WHERE
3751: k.release_errors IS NULL
3752: AND (k.releasable = ' || RELEASABLE || ' or k.releasable is null )
3753: AND k.sr_instance_id = '||p_arg_org_instance|| '

Line 4001: msc_system_items msi,

3997: s2.new_order_quantity defective_part_quantity
3998: FROM msc_supplies s,
3999: Msc_supplies s1,
4000: Msc_supplies s2 ,
4001: msc_system_items msi,
4002: msc_system_items msi1,
4003: msc_trading_partners mtp,
4004: msc_trading_partners mtp1,
4005: msc_demands d ,

Line 4002: msc_system_items msi1,

3998: FROM msc_supplies s,
3999: Msc_supplies s1,
4000: Msc_supplies s2 ,
4001: msc_system_items msi,
4002: msc_system_items msi1,
4003: msc_trading_partners mtp,
4004: msc_trading_partners mtp1,
4005: msc_demands d ,
4006: msc_demands d1,

Line 4155: msc_system_items msi,

4151: msi1.sr_inventory_item_id defective_item_id,
4152: s2.new_order_quantity defective_part_quantity
4153: FROM
4154: msc_supplies k,
4155: msc_system_items msi,
4156: msc_part_supplies s,
4157: msc_part_demands d,
4158: Msc_part_supplies s1,
4159: msc_trading_partners mtp,

Line 4164: msc_system_items msi1,

4160: msc_trading_partners mtp1,
4161: msc_part_demands d1,
4162: Msc_part_supplies s2,
4163: msc_part_demands d2,
4164: msc_system_items msi1,
4165: (select distinct transaction_id,plan_id,organization_id ,sr_instance_id ,demand_id
4166: from msc_part_pegging
4167: where sr_instance_id = '||p_arg_org_instance||'
4168: and plan_id ='||p_arg_plan_id||'

Line 4363: msc_system_items msi,

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

Line 4605: msc_system_items msi,

4601: , s.schedule_priority
4602: , nvl(s.requested_completion_date, s.need_by_date)
4603: FROM msc_trading_partners tp,
4604: msc_parameters param,
4605: msc_system_items msi,
4606: msc_process_effectivity mpe,
4607: msc_supplies s
4608: WHERE tp.sr_tp_id= msi.organization_id
4609: AND tp.sr_instance_id= msi.sr_instance_id

Line 4840: msc_system_items msi

4836: msc_resource_requirements res,
4837: msc_apps_instances ins,
4838: msc_parameters param,
4839: msc_department_resources mdr,
4840: msc_system_items msi
4841: Where res.plan_id = s.plan_id
4842: AND res.sr_instance_id = s.sr_instance_id
4843: AND s.transaction_id = res.supply_id
4844: AND res.parent_id = 2

Line 4923: msc_system_items icomp,

4919: 3,
4920: s.sr_instance_id
4921: From msc_supplies s,
4922: msc_demands md,
4923: msc_system_items icomp,
4924: msc_system_items icomp1,
4925: msc_system_items icomp2,
4926: msc_apps_instances ins,
4927: msc_parameters param

Line 4924: msc_system_items icomp1,

4920: s.sr_instance_id
4921: From msc_supplies s,
4922: msc_demands md,
4923: msc_system_items icomp,
4924: msc_system_items icomp1,
4925: msc_system_items icomp2,
4926: msc_apps_instances ins,
4927: msc_parameters param
4928: Where /* not exists (select 'x'

Line 4925: msc_system_items icomp2,

4921: From msc_supplies s,
4922: msc_demands md,
4923: msc_system_items icomp,
4924: msc_system_items icomp1,
4925: msc_system_items icomp2,
4926: msc_apps_instances ins,
4927: msc_parameters param
4928: Where /* not exists (select 'x'
4929: from msc_exception_details excp

Line 5537: msc_system_items msi,

5533: , s.schedule_priority
5534: , s.requested_completion_date
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

Line 5785: msc_system_items msi

5781: msc_resource_requirements res,
5782: msc_apps_instances ins,
5783: msc_parameters param,
5784: msc_department_resources mdr,
5785: msc_system_items msi
5786: Where res.plan_id = s.plan_id
5787: AND res.sr_instance_id = s.sr_instance_id
5788: AND s.transaction_id = res.supply_id
5789: AND res.parent_id = 2

Line 5870: msc_system_items icomp,

5866: 3,
5867: s.sr_instance_id
5868: From msc_supplies s,
5869: msc_demands md,
5870: msc_system_items icomp,
5871: msc_system_items icomp1,
5872: msc_system_items icomp2,
5873: msc_apps_instances ins,
5874: msc_parameters param

Line 5871: msc_system_items icomp1,

5867: s.sr_instance_id
5868: From msc_supplies s,
5869: msc_demands md,
5870: msc_system_items icomp,
5871: msc_system_items icomp1,
5872: msc_system_items icomp2,
5873: msc_apps_instances ins,
5874: msc_parameters param
5875: Where /* not exists (select 'x'

Line 5872: msc_system_items icomp2,

5868: From msc_supplies s,
5869: msc_demands md,
5870: msc_system_items icomp,
5871: msc_system_items icomp1,
5872: msc_system_items icomp2,
5873: msc_apps_instances ins,
5874: msc_parameters param
5875: Where /* not exists (select 'x'
5876: from msc_exception_details excp

Line 6400: msc_system_items msi,

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

Line 6745: msc_system_items msi,

6741: , s.schedule_priority
6742: , nvl(s.requested_completion_date, s.need_by_date)
6743: FROM msc_trading_partners tp,
6744: msc_parameters param,
6745: msc_system_items msi,
6746: msc_process_effectivity mpe,
6747: msc_supplies s,
6748: msc_boms mb
6749: WHERE tp.sr_tp_id= msi.organization_id

Line 6884: msc_system_items msi,

6880: s.sr_instance_id
6881: FROM msc_trading_partners tp,
6882: msc_resource_requirements resreq,
6883: msc_parameters param,
6884: msc_system_items msi,
6885: msc_supplies s
6886: WHERE tp.sr_tp_id= msi.organization_id
6887: AND tp.sr_instance_id= msi.sr_instance_id
6888: AND tp.partner_type=3

Line 7046: msc_system_items msi,

7042: , resreq.resource_seq_num
7043: FROM msc_trading_partners tp,
7044: msc_resource_requirements resreq,
7045: msc_parameters param,
7046: msc_system_items msi,
7047: msc_supplies s,
7048: msc_department_resources mdr
7049: WHERE tp.sr_tp_id= msi.organization_id
7050: AND tp.sr_instance_id= msi.sr_instance_id

Line 7169: msc_system_items icomp,

7165: -- md.operation_seq_id,
7166: nvl(s.implement_uom_code,msi.uom_code),
7167: s.sr_instance_id
7168: FROM msc_trading_partners tp,
7169: msc_system_items icomp,
7170: msc_demands md,
7171: msc_parameters param,
7172: msc_system_items msi,
7173: msc_supplies s

Line 7172: msc_system_items msi,

7168: FROM msc_trading_partners tp,
7169: msc_system_items icomp,
7170: msc_demands md,
7171: msc_parameters param,
7172: msc_system_items msi,
7173: msc_supplies s
7174: WHERE /*
7175: ( md.SUBST_ITEM_FLAG <> 1
7176: OR md.SUBST_ITEM_FLAG IS NULL) */

Line 7279: msc_system_items icomp,

7275: TO_CHAR(NULL),
7276: nvl(s.implement_uom_code,msi.uom_code),
7277: s.sr_instance_id
7278: FROM msc_trading_partners tp,
7279: msc_system_items icomp,
7280: msc_supplies co,
7281: msc_parameters param,
7282: msc_system_items msi,
7283: msc_supplies s

Line 7282: msc_system_items msi,

7278: FROM msc_trading_partners tp,
7279: msc_system_items icomp,
7280: msc_supplies co,
7281: msc_parameters param,
7282: msc_system_items msi,
7283: msc_supplies s
7284: WHERE /* not exists (select 'x'
7285: from msc_exception_details excp
7286: where excp.plan_id = msi.plan_id

Line 7399: msc_system_items icomp,

7395: msc_bom_components subcomp,
7396: msc_component_substitutes bsub,
7397: /* msc_bom_components bcomp, */
7398: msc_boms bom,
7399: msc_system_items icomp,
7400: msc_demands md,
7401: msc_parameters param,
7402: msc_system_items msi,
7403: msc_supplies s

Line 7402: msc_system_items msi,

7398: msc_boms bom,
7399: msc_system_items icomp,
7400: msc_demands md,
7401: msc_parameters param,
7402: msc_system_items msi,
7403: msc_supplies s
7404: WHERE tp.sr_tp_id= msi.organization_id
7405: AND tp.sr_instance_id= msi.sr_instance_id
7406: AND tp.partner_type=3

Line 7547: msc_system_items msi,

7543: resreq.parent_seq_num
7544: FROM msc_trading_partners tp,
7545: msc_resource_requirements resreq,
7546: msc_parameters param,
7547: msc_system_items msi,
7548: msc_supplies s,
7549: msc_department_resources mdr
7550: WHERE tp.sr_tp_id= msi.organization_id
7551: AND tp.sr_instance_id= msi.sr_instance_id

Line 8273: msc_system_items msi,

8269: , s.schedule_priority -- dsr
8270: , s.requested_completion_date -- dsr
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

Line 8409: msc_system_items msi,

8405: , decode(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr
8406: FROM msc_trading_partners tp,
8407: msc_resource_requirements resreq,
8408: msc_parameters param,
8409: msc_system_items msi,
8410: msc_supplies s
8411: WHERE tp.sr_tp_id= msi.organization_id
8412: AND tp.sr_instance_id= msi.sr_instance_id
8413: AND tp.partner_type=3

Line 8565: msc_system_items msi,

8561: , resreq.resource_seq_num
8562: FROM msc_trading_partners tp,
8563: msc_resource_requirements resreq,
8564: msc_parameters param,
8565: msc_system_items msi,
8566: msc_supplies s
8567: WHERE tp.sr_tp_id= msi.organization_id
8568: AND tp.sr_instance_id= msi.sr_instance_id
8569: AND tp.partner_type=3

Line 8689: msc_system_items icomp,

8685: nvl(s.implement_uom_code, msi.uom_code),
8686: s.disposition_id
8687: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
8688: FROM msc_trading_partners tp,
8689: msc_system_items icomp,
8690: msc_demands md,
8691: msc_parameters param,
8692: msc_system_items msi,
8693: msc_supplies s

Line 8692: msc_system_items msi,

8688: FROM msc_trading_partners tp,
8689: msc_system_items icomp,
8690: msc_demands md,
8691: msc_parameters param,
8692: msc_system_items msi,
8693: msc_supplies s
8694: WHERE /*
8695: ( md.SUBST_ITEM_FLAG <> 1
8696: OR md.SUBST_ITEM_FLAG IS NULL) */

Line 8823: msc_system_items icomp,

8819: nvl(s.implement_uom_code, msi.uom_code),
8820: s.disposition_id
8821: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
8822: FROM msc_trading_partners tp,
8823: msc_system_items icomp,
8824: msc_supplies co,
8825: msc_parameters param,
8826: msc_system_items msi,
8827: msc_supplies s

Line 8826: msc_system_items msi,

8822: FROM msc_trading_partners tp,
8823: msc_system_items icomp,
8824: msc_supplies co,
8825: msc_parameters param,
8826: msc_system_items msi,
8827: msc_supplies s
8828: WHERE /*not exists (select 'x'
8829: from msc_exception_details excp
8830: where excp.plan_id = msi.plan_id

Line 8960: msc_system_items msi,

8956: ,resreq.parent_seq_num
8957: FROM msc_trading_partners tp,
8958: msc_resource_requirements resreq,
8959: msc_parameters param,
8960: msc_system_items msi,
8961: msc_supplies s
8962: WHERE tp.sr_tp_id= msi.organization_id
8963: AND tp.sr_instance_id= msi.sr_instance_id
8964: AND tp.partner_type=3

Line 9410: msc_system_items msi,

9406: nvl(s.implement_uom_code,msi.uom_code),
9407: s.sr_instance_id
9408: FROM msc_trading_partners tp,
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

Line 9654: msc_system_items msi,

9650: msc_tp_id_lid supplier,
9651: msc_trading_partner_sites mtps,
9652: msc_trading_partners mp, -- mtl_parameters mp,
9653: msc_trading_partners mp1,
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

Line 9655: msc_system_items msi1,

9651: msc_trading_partner_sites mtps,
9652: msc_trading_partners mp, -- mtl_parameters mp,
9653: msc_trading_partners mp1,
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(+)=

Line 9800: msc_system_items msi,

9796: msc_tp_id_lid supplier,
9797: msc_trading_partner_sites mtps,
9798: msc_trading_partners mp, -- mtl_parameters mp,
9799: msc_trading_partners mp1,
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

Line 9801: msc_system_items msi1,

9797: msc_trading_partner_sites mtps,
9798: msc_trading_partners mp, -- mtl_parameters mp,
9799: msc_trading_partners mp1,
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(+)=

Line 9945: msc_system_items msi,

9941: msc_tp_id_lid supplier,
9942: msc_trading_partner_sites mtps,
9943: msc_trading_partners mp, -- mtl_parameters mp,
9944: msc_trading_partners mp1,
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

Line 9946: msc_system_items msi1,

9942: msc_trading_partner_sites mtps,
9943: msc_trading_partners mp, -- mtl_parameters mp,
9944: msc_trading_partners mp1,
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(+)=

Line 10100: msc_system_items msi,

10096: g_batch_id
10097: FROM --msc_calendar_dates cal1,
10098: --msc_calendar_dates cal2,
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

Line 10159: msc_system_items msi,

10155: g_batch_id
10156: FROM --msc_calendar_dates cal1,
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

Line 10268: msc_system_items msi,

10264: lv_po_number
10265: FROM --msc_calendar_dates cal1,
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

Line 10439: from msc_system_items msi

10435: 'MSC',
10436: msi.organization_id,
10437: 257,
10438: -23453
10439: from msc_system_items msi
10440: ,msc_item_attributes mia
10441: where msi.inventory_item_id = mia.inventory_item_id
10442: and msi.organization_id = mia.organization_id
10443: and mia.repair_module = CMRO

Line 10460: msc_system_items msi,

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
10463: WHERE mp.plan_id = :p_arg_plan_id
10464: AND s.release_errors is NULL

Line 10653: msc_system_items msi,

10649: , s.schedule_priority
10650: , nvl(s.requested_completion_date, s.need_by_date)
10651: FROM msc_trading_partners tp,
10652: msc_parameters param,
10653: msc_system_items msi,
10654: msc_process_effectivity mpe,
10655: msc_supplies s
10656: WHERE tp.sr_tp_id= msi.organization_id
10657: AND tp.sr_instance_id= msi.sr_instance_id

Line 11044: msc_system_items msi,

11040: , s.schedule_priority
11041: , s.requested_completion_date
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

Line 11163: msc_system_items msi,

11159: , decode(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr
11160: FROM msc_trading_partners tp,
11161: msc_resource_requirements resreq,
11162: msc_parameters param,
11163: msc_system_items msi,
11164: msc_supplies s
11165: WHERE tp.sr_tp_id= msi.organization_id
11166: AND tp.sr_instance_id= msi.sr_instance_id
11167: AND tp.partner_type=3

Line 11314: msc_system_items msi,

11310: , resreq.resource_seq_num
11311: FROM msc_trading_partners tp,
11312: msc_resource_requirements resreq,
11313: msc_parameters param,
11314: msc_system_items msi,
11315: msc_supplies s
11316: WHERE tp.sr_tp_id= msi.organization_id
11317: AND tp.sr_instance_id= msi.sr_instance_id
11318: AND tp.partner_type=3

Line 11416: msc_system_items icomp,

11412: nvl(s.implement_uom_code, msi.uom_code),
11413: s.disposition_id
11414: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
11415: FROM msc_trading_partners tp,
11416: msc_system_items icomp,
11417: msc_demands md,
11418: msc_parameters param,
11419: msc_system_items msi,
11420: msc_supplies s

Line 11419: msc_system_items msi,

11415: FROM msc_trading_partners tp,
11416: msc_system_items icomp,
11417: msc_demands md,
11418: msc_parameters param,
11419: msc_system_items msi,
11420: msc_supplies s
11421: WHERE /*
11422: ( md.SUBST_ITEM_FLAG <> 1
11423: OR md.SUBST_ITEM_FLAG IS NULL) */

Line 11532: msc_system_items icomp,

11528: nvl(s.implement_uom_code, msi.uom_code),
11529: s.disposition_id
11530: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
11531: FROM msc_trading_partners tp,
11532: msc_system_items icomp,
11533: msc_supplies co,
11534: msc_parameters param,
11535: msc_system_items msi,
11536: msc_supplies s

Line 11535: msc_system_items msi,

11531: FROM msc_trading_partners tp,
11532: msc_system_items icomp,
11533: msc_supplies co,
11534: msc_parameters param,
11535: msc_system_items msi,
11536: msc_supplies s
11537: WHERE /*not exists (select 'x'
11538: from msc_exception_details excp
11539: where excp.plan_id = msi.plan_id

Line 11662: msc_system_items msi,

11658: ,resreq.parent_seq_num
11659: FROM msc_trading_partners tp,
11660: msc_resource_requirements resreq,
11661: msc_parameters param,
11662: msc_system_items msi,
11663: msc_supplies s
11664: WHERE tp.sr_tp_id= msi.organization_id
11665: AND tp.sr_instance_id= msi.sr_instance_id
11666: AND tp.partner_type=3

Line 12373: msc_system_items msi,

12369: , s.schedule_priority
12370: , s.requested_completion_date
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

Line 12492: msc_system_items msi,

12488: , decode(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr
12489: FROM msc_trading_partners tp,
12490: msc_resource_requirements resreq,
12491: msc_parameters param,
12492: msc_system_items msi,
12493: msc_supplies s
12494: WHERE tp.sr_tp_id= msi.organization_id
12495: AND tp.sr_instance_id= msi.sr_instance_id
12496: AND tp.partner_type=3

Line 12643: msc_system_items msi,

12639: , resreq.resource_seq_num
12640: FROM msc_trading_partners tp,
12641: msc_resource_requirements resreq,
12642: msc_parameters param,
12643: msc_system_items msi,
12644: msc_supplies s
12645: WHERE tp.sr_tp_id= msi.organization_id
12646: AND tp.sr_instance_id= msi.sr_instance_id
12647: AND tp.partner_type=3

Line 12746: msc_system_items icomp,

12742: nvl(s.implement_uom_code, msi.uom_code),
12743: s.disposition_id
12744: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
12745: FROM msc_trading_partners tp,
12746: msc_system_items icomp,
12747: msc_demands md,
12748: msc_parameters param,
12749: msc_system_items msi,
12750: msc_supplies s

Line 12749: msc_system_items msi,

12745: FROM msc_trading_partners tp,
12746: msc_system_items icomp,
12747: msc_demands md,
12748: msc_parameters param,
12749: msc_system_items msi,
12750: msc_supplies s
12751: WHERE /*
12752: ( md.SUBST_ITEM_FLAG <> 1
12753: OR md.SUBST_ITEM_FLAG IS NULL)

Line 12863: msc_system_items icomp,

12859: nvl(s.implement_uom_code, msi.uom_code),
12860: s.disposition_id
12861: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
12862: FROM msc_trading_partners tp,
12863: msc_system_items icomp,
12864: msc_supplies co,
12865: msc_parameters param,
12866: msc_system_items msi,
12867: msc_supplies s

Line 12866: msc_system_items msi,

12862: FROM msc_trading_partners tp,
12863: msc_system_items icomp,
12864: msc_supplies co,
12865: msc_parameters param,
12866: msc_system_items msi,
12867: msc_supplies s
12868: WHERE /*not exists (select 'x'
12869: from msc_exception_details excp
12870: where excp.plan_id = msi.plan_id

Line 12993: msc_system_items msi,

12989: ,resreq.parent_seq_num
12990: FROM msc_trading_partners tp,
12991: msc_resource_requirements resreq,
12992: msc_parameters param,
12993: msc_system_items msi,
12994: msc_supplies s
12995: WHERE tp.sr_tp_id= msi.organization_id
12996: AND tp.sr_instance_id= msi.sr_instance_id
12997: AND tp.partner_type=3

Line 13429: msc_system_items icompold,

13425: nvl(ms.implement_uom_code, msi.uom_code),
13426: ms.disposition_id
13427: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
13428: FROM msc_trading_partners tp,
13429: msc_system_items icompold,
13430: msc_system_items icompnew,
13431: msc_demands md,
13432: msc_parameters param,
13433: msc_system_items msi,

Line 13430: msc_system_items icompnew,

13426: ms.disposition_id
13427: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
13428: FROM msc_trading_partners tp,
13429: msc_system_items icompold,
13430: msc_system_items icompnew,
13431: msc_demands md,
13432: msc_parameters param,
13433: msc_system_items msi,
13434: msc_supplies ms,

Line 13433: msc_system_items msi,

13429: msc_system_items icompold,
13430: msc_system_items icompnew,
13431: msc_demands md,
13432: msc_parameters param,
13433: msc_system_items msi,
13434: msc_supplies ms,
13435: msc_exception_details med
13436: WHERE med.exception_type = WORK_ORDER_SUB_COMPONENT
13437: AND med.plan_id = arg_plan_id