APPS.MSC_GET_GANTT_DATA dependencies on MSC_EXCEPTION_DETAILS

Line 140: FROM msc_exception_details

136: , p_resource_id IN number
137: , p_transaction_id IN number
138: ) IS
139: SELECT 'EXISTS'
140: FROM msc_exception_details
141: WHERE number1 = p_transaction_id
142: AND sr_instance_id = p_instance_id
143: AND plan_id = p_plan_id
144: and exception_type =36

Line 3081: ' msc_exception_details med ' ||

3077: ' mrr.sr_instance_id) end_date '||
3078: ' FROM msc_resource_requirements mrr, ' ||
3079: ' msc_supplies ms, ' ||
3080: ' msc_trading_partners mtp, ' ||
3081: ' msc_exception_details med ' ||
3082: ' WHERE ms.plan_id = :1 '||
3083: ' and mrr.plan_id = ms.plan_id ' ||
3084: ' and mrr.supply_id = ms.transaction_id ' ||
3085: ' and mrr.sr_instance_id = ms.sr_instance_id ' ||

Line 3239: ' msc_exception_details med '||

3235: 'SELECT mrr.sr_instance_id, '||
3236: ' mrr.transaction_id '||
3237: -- ' med.exception_detail_id '||
3238: ' FROM msc_supplies mrr, '||
3239: ' msc_exception_details med '||
3240: ' WHERE mrr.plan_id = '||p_plan_id ||
3241: ' and mrr.plan_id = med.plan_id '||
3242: ' and ( (mrr.transaction_id = med.number1 and '||
3243: ' med.exception_type in (6,7,8,9,10,32,34,53,54,58))'||

Line 3250: ' msc_exception_details med '||

3246: ' union select mrr.sr_instance_id, '||
3247: ' mrr.supply_id transaction_id '||
3248: -- ' med.exception_detail_id '||
3249: ' FROM msc_resource_requirements mrr, '||
3250: ' msc_exception_details med '||
3251: ' where med.exception_type in (21,22,36,45,46) '||
3252: ' AND med.plan_id = mrr.plan_id ' ||
3253: ' AND med.organization_id = mrr.organization_id ' ||
3254: ' AND med.sr_instance_id = mrr.sr_instance_id ' ||

Line 3315: ' msc_exception_details med ' ||

3311: ' mrr.department_id, '||
3312: ' mrr.resource_id '||
3313: ' FROM msc_resource_requirements mrr, ' ||
3314: ' msc_department_resources mdr, ' ||
3315: ' msc_exception_details med ' ||
3316: ' WHERE mrr.plan_id = :1 '||
3317: ' AND mdr.plan_id = mrr.plan_id '||
3318: ' AND mdr.organization_id = mrr.organization_id ' ||
3319: ' AND mdr.sr_instance_id = mrr.sr_instance_id'||

Line 6039: msc_exception_details med,

6035: md.USING_REQUIREMENT_QUANTITY||')' ,
6036: md.using_assembly_demand_date
6037: bulk collect into v_demand_id, v_order_name , v_dummy_date
6038: FROM
6039: msc_exception_details med,
6040: msc_demands md,
6041: msc_demands md2
6042: where md2.plan_id = p_plan_id
6043: and md2.demand_id = p_demand_id

Line 6524: from msc_exception_details

6520: p_inventory_item_id number,
6521: p_transaction_id number) RETURN NUMBER IS
6522: CURSOR C IS
6523: select 1
6524: from msc_exception_details
6525: WHERE number1 = p_transaction_id
6526: AND sr_instance_id = p_instance_id
6527: AND plan_id = p_plan_id
6528: and exception_type =36