[Home] [Help]
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
4930: where excp.plan_id = s.plan_id
4931: and excp.number1 = s.transaction_id
4932: and excp.inventory_item_id = s.inventory_item_id
4933: and excp.organization_id = s.organization_id
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
5877: where excp.plan_id = s.plan_id
5878: and excp.number1 = s.transaction_id
5879: and excp.inventory_item_id = s.inventory_item_id
5880: and excp.organization_id = s.organization_id
6294: AND plan_id = p_plan_id
6295: and rownum < 2
6296: UNION
6297: SELECT count(1)
6298: from msc_exception_details excp
6299: where excp.plan_id = p_plan_id
6300: and number1 = p_transaction_id
6301: and excp.exception_type = 33
6302: and rownum < 2);
6349: s.sr_instance_id,
6350: Decode(' ||l_plan_type ||', 5, -- dsting for drp look at alternate bom/subst exception to determine whether or not to release dtls
6351: Decode(implement_alternate_bom, NULL,
6352: (SELECT Decode(COUNT(1), 1, 1, 2)
6353: FROM msc_exception_details e
6354: WHERE e.plan_id = :arg_plan_id
6355: AND e.number1 = s.transaction_id
6356: AND e.exception_type = 33), 1),
6357: decode( mp.daily_material_constraints+ mp.daily_resource_constraints+
6805: -- dsting redo the details enabled flag for things with subst comp
6806: for i IN 1..lv_transaction_id.count loop
6807: SELECT count(1)
6808: INTO l_sub_comp_count
6809: from msc_exception_details excp
6810: where excp.plan_id = arg_plan_id
6811: and number1 = lv_transaction_id(i)
6812: and excp.exception_type = 33
6813: and rownum < 2;
7174: WHERE /*
7175: ( md.SUBST_ITEM_FLAG <> 1
7176: OR md.SUBST_ITEM_FLAG IS NULL) */
7177: not exists (select 'x'
7178: from msc_exception_details excp
7179: where excp.plan_id = msi.plan_id
7180: and excp.number1 = s.transaction_id
7181: and excp.inventory_item_id = msi.inventory_item_id
7182: and excp.organization_id = msi.organization_id
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
7287: and excp.number1 = s.transaction_id
7288: and excp.inventory_item_id = msi.inventory_item_id
7289: and excp.organization_id = msi.organization_id
7952: and transaction_id = p_transaction_id
7953: and rownum < 2
7954: UNION
7955: SELECT count(1)
7956: from msc_exception_details excp
7957: where excp.plan_id = p_plan_id
7958: and number1 = p_transaction_id
7959: and excp.exception_type = 33
7960: and rownum < 2;
8694: WHERE /*
8695: ( md.SUBST_ITEM_FLAG <> 1
8696: OR md.SUBST_ITEM_FLAG IS NULL) */
8697: not exists (select 'x'
8698: from msc_exception_details excp
8699: where excp.plan_id = msi.plan_id
8700: and excp.number1 = s.transaction_id
8701: and excp.inventory_item_id = msi.inventory_item_id
8702: and excp.organization_id = msi.organization_id
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
8831: and excp.number1 = s.transaction_id
8832: and excp.inventory_item_id = msi.inventory_item_id
8833: and excp.organization_id = msi.organization_id
10753: and transaction_id = p_transaction_id
10754: and rownum < 2
10755: UNION
10756: SELECT count(1)
10757: from msc_exception_details excp
10758: where excp.plan_id = p_plan_id
10759: and number1 = p_transaction_id
10760: and excp.exception_type = 33
10761: and rownum < 2;
11421: WHERE /*
11422: ( md.SUBST_ITEM_FLAG <> 1
11423: OR md.SUBST_ITEM_FLAG IS NULL) */
11424: not exists (select 'x'
11425: from msc_exception_details excp
11426: where excp.plan_id = msi.plan_id
11427: and excp.number1 = s.transaction_id
11428: and excp.inventory_item_id = msi.inventory_item_id
11429: and excp.organization_id = msi.organization_id
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
11540: and excp.number1 = s.transaction_id
11541: and excp.inventory_item_id = msi.inventory_item_id
11542: and excp.organization_id = msi.organization_id
12082: and transaction_id = p_transaction_id
12083: and rownum < 2
12084: UNION
12085: SELECT count(1)
12086: from msc_exception_details excp
12087: where excp.plan_id = p_plan_id
12088: and number1 = p_transaction_id
12089: and excp.exception_type = 33
12090: and rownum < 2;
12751: WHERE /*
12752: ( md.SUBST_ITEM_FLAG <> 1
12753: OR md.SUBST_ITEM_FLAG IS NULL)
12754: not exists (select 'x'
12755: from msc_exception_details excp
12756: where excp.plan_id = msi.plan_id
12757: and excp.number1 = s.transaction_id
12758: and excp.inventory_item_id = msi.inventory_item_id
12759: and excp.organization_id = msi.organization_id
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
12871: and excp.number1 = s.transaction_id
12872: and excp.inventory_item_id = msi.inventory_item_id
12873: and excp.organization_id = msi.organization_id
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
13438: and med.number1 = ms.transaction_id
13439: and med.inventory_item_id = ms.inventory_item_id