APPS.MSC_REL_PLAN_PUB dependencies on MSC_EXCEPTION_DETAILS

Line 4380: from msc_exception_details excp

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
4381: where excp.plan_id = s.plan_id
4382: and excp.number1 = s.transaction_id
4383: and excp.inventory_item_id = s.inventory_item_id
4384: and excp.organization_id = s.organization_id

Line 5320: from msc_exception_details excp

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
5321: where excp.plan_id = s.plan_id
5322: and excp.number1 = s.transaction_id
5323: and excp.inventory_item_id = s.inventory_item_id
5324: and excp.organization_id = s.organization_id

Line 5729: from msc_exception_details excp

5725: AND plan_id = p_plan_id
5726: and rownum < 2
5727: UNION
5728: SELECT count(1)
5729: from msc_exception_details excp
5730: where excp.plan_id = p_plan_id
5731: and number1 = p_transaction_id
5732: and excp.exception_type = 33
5733: and rownum < 2);

Line 5777: FROM msc_exception_details e

5773: s.sr_instance_id,
5774: Decode(' ||l_plan_type ||', 5, -- dsting for drp look at alternate bom/subst exception to determine whether or not to release dtls
5775: Decode(implement_alternate_bom, NULL,
5776: (SELECT Decode(COUNT(1), 1, 1, 2)
5777: FROM msc_exception_details e
5778: WHERE e.plan_id = :arg_plan_id
5779: AND e.number1 = s.transaction_id
5780: AND e.exception_type = 33), 1),
5781: decode( mp.daily_material_constraints+ mp.daily_resource_constraints+

Line 6140: from msc_exception_details excp

6136: -- dsting redo the details enabled flag for things with subst comp
6137: for i IN 1..lv_transaction_id.count loop
6138: SELECT count(1)
6139: INTO l_sub_comp_count
6140: from msc_exception_details excp
6141: where excp.plan_id = arg_plan_id
6142: and number1 = lv_transaction_id(i)
6143: and excp.exception_type = 33
6144: and rownum < 2;

Line 6504: from msc_exception_details excp

6500: WHERE /*
6501: ( md.SUBST_ITEM_FLAG <> 1
6502: OR md.SUBST_ITEM_FLAG IS NULL) */
6503: not exists (select 'x'
6504: from msc_exception_details excp
6505: where excp.plan_id = msi.plan_id
6506: and excp.number1 = s.transaction_id
6507: and excp.inventory_item_id = msi.inventory_item_id
6508: and excp.organization_id = msi.organization_id

Line 6606: from msc_exception_details excp

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
6608: and excp.number1 = s.transaction_id
6609: and excp.inventory_item_id = msi.inventory_item_id
6610: and excp.organization_id = msi.organization_id

Line 7265: from msc_exception_details excp

7261: and transaction_id = p_transaction_id
7262: and rownum < 2
7263: UNION
7264: SELECT count(1)
7265: from msc_exception_details excp
7266: where excp.plan_id = p_plan_id
7267: and number1 = p_transaction_id
7268: and excp.exception_type = 33
7269: and rownum < 2;

Line 7882: from msc_exception_details excp

7878: WHERE /*
7879: ( md.SUBST_ITEM_FLAG <> 1
7880: OR md.SUBST_ITEM_FLAG IS NULL) */
7881: not exists (select 'x'
7882: from msc_exception_details excp
7883: where excp.plan_id = msi.plan_id
7884: and excp.number1 = s.transaction_id
7885: and excp.inventory_item_id = msi.inventory_item_id
7886: and excp.organization_id = msi.organization_id

Line 7993: from msc_exception_details excp

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
7995: and excp.number1 = s.transaction_id
7996: and excp.inventory_item_id = msi.inventory_item_id
7997: and excp.organization_id = msi.organization_id