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_GET_NAME dependencies on MSC_SUPPLIES

Line 198: from msc_supplies ms,

194: END IF;
195:
196: select ms.new_schedule_date
197: into var_date
198: from msc_supplies ms,
199: msc_full_pegging mfp
200: where ms.transaction_id = mfp.transaction_id
201: and ms.plan_id=mfp.plan_id
202: and mfp.pegging_id = arg_pegging_id

Line 423: from msc_supplies

419: order_num varchar2(240);
420:
421: cursor order_number_c is
422: select order_number
423: from msc_supplies
424: where disposition_id in
425: (select disposition_id
426: from msc_demands
427: where plan_id = arg_plan_id

Line 436: from msc_supplies

432: and order_type in (1,2,8,11,12);
433:
434: cursor wip_entity_name_c is
435: select wip_entity_name
436: from msc_supplies
437: where disposition_id in
438: (select disposition_id
439: from msc_demands
440: where plan_id = arg_plan_id

Line 514: from msc_supplies

510: END IF;
511: -- if arg_sr_instance_id is null then
512: select order_number, order_type
513: into order_num, v_type
514: from msc_supplies
515: where transaction_id = arg_transaction_id
516: and plan_id = arg_plan_id;
517: -- else
518: select order_number, order_type

Line 520: from msc_supplies

516: and plan_id = arg_plan_id;
517: -- else
518: select order_number, order_type
519: into order_num, v_type
520: from msc_supplies
521: where transaction_id = arg_transaction_id
522: and plan_id = arg_plan_id
523: and sr_instance_id = arg_sr_instance_id;
524: -- end if;

Line 554: from msc_supplies

550: END IF;
551:
552: select lookup_meaning('MRP_ORDER_TYPE', order_type)
553: into v_order_type
554: from msc_supplies
555: where transaction_id = arg_transaction_id
556: and plan_id = arg_plan_id;
557:
558: return (v_order_type);

Line 576: from msc_supplies

572: END IF;
573:
574: select order_type
575: into v_order_type
576: from msc_supplies
577: where transaction_id = arg_transaction_id
578: and plan_id = arg_plan_id
579: and sr_instance_id = arg_instance_id;
580:

Line 1251: msc_get_name.action('MSC_SUPPLIES', msi.bom_item_type,

1247:
1248: CURSOR internal_sales(p_plan_id number,
1249: p_tran_id number, p_inst_id number) IS
1250: select ms.disposition_status_type,
1251: msc_get_name.action('MSC_SUPPLIES', msi.bom_item_type,
1252: msi.base_item_id, msi.wip_supply_type, ms.order_type,
1253: DECODE(ms.firm_planned_type,1,1,ms.reschedule_flag),
1254: ms.disposition_status_type,
1255: ms.new_schedule_date, ms.old_schedule_date,

Line 1262: from msc_supplies ms,

1258: msi.release_time_fence_code, ms.reschedule_days,
1259: ms.firm_quantity,ms.plan_id,
1260: msi.critical_component_flag, msi.mrp_planning_code,
1261: msi.lots_exist)
1262: from msc_supplies ms,
1263: msc_system_items msi
1264: where ms.plan_id = p_plan_id
1265: and ms.transaction_id = p_tran_id
1266: and ms.sr_instance_id = p_inst_id

Line 1317: IF arg_source_table = 'MSC_SUPPLIES' THEN

1313: p_old_date_index number;
1314:
1315: BEGIN
1316:
1317: IF arg_source_table = 'MSC_SUPPLIES' THEN
1318: IF arg_lots_exist = 2 and
1319: arg_order_type =5 and
1320: arg_quantity_rate <> 0 then
1321: -- plan generated planned order from supply schedule

Line 1454: -- This record does note come from MSC_SUPPLIES

1450: END IF;
1451:
1452: ELSE
1453:
1454: -- This record does note come from MSC_SUPPLIES
1455: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);
1456: IF NVL(arg_release_time_fence_code,-1) = 7 THEN
1457: -- Shikyu item
1458: RETURN l_action;

Line 1942: FROM msc_supplies

1938: FUNCTION wip_status(p_transaction_id IN NUMBER) return number IS
1939:
1940: CURSOR wip_cur IS
1941: SELECT wip_status_code
1942: FROM msc_supplies
1943: WHERE plan_id = -1
1944: and transaction_id = p_transaction_id;
1945: l_status number;
1946:

Line 2995: from msc_supplies

2991: p_transaction_id in number,
2992: p_coprod in number default 0) return varchar2 is
2993: cursor order_num_c is
2994: select wip_entity_name , order_number
2995: from msc_supplies
2996: where plan_id=p_plan_id
2997: and sr_instance_id = p_inst_id
2998: and transaction_id= p_transaction_id;
2999:

Line 3079: from msc_supplies mr,

3075: end if;
3076:
3077: select (mif.unit_weight * mr.new_order_quantity)
3078: into l_req_capacity
3079: from msc_supplies mr,
3080: msc_system_items mif
3081: where mr.plan_id = mif.plan_id
3082: and mr.sr_instance_id = mif.sr_instance_id
3083: and mr.organization_id = mif.organization_id

Line 3337: from msc_supplies

3333: END IF;
3334:
3335: select new_schedule_date
3336: into l_date
3337: from msc_supplies
3338: where transaction_id = arg_trx_id
3339: and plan_id = arg_plan_id;
3340:
3341: return l_date;

Line 4067: from msc_supplies

4063: l_supply_order_number varchar2(2000);
4064:
4065: cursor curr_supply(p_curr_plan_id number , p_curr_inst_id number , p_curr_trans_id number) is
4066: select order_number , order_type , disposition_id
4067: from msc_supplies
4068: where plan_id = p_curr_plan_id
4069: and sr_instance_id = p_curr_inst_id
4070: and transaction_id = p_curr_trans_id;
4071: begin

Line 4097: from msc_supplies

4093: l_supply_item varchar2(2000);
4094:
4095: cursor curr_supply(p_curr_plan_id number , p_curr_inst_id number , p_curr_trans_id number) is
4096: select inventory_item_id , organization_id
4097: from msc_supplies
4098: where plan_id = p_curr_plan_id
4099: and sr_instance_id = p_curr_inst_id
4100: and transaction_id = p_curr_trans_id;
4101: begin

Line 4123: from msc_supplies

4119: l_supply_org_code varchar2(100);
4120:
4121: cursor curr_supply(p_curr_plan_id number , p_curr_inst_id number , p_curr_trans_id number) is
4122: select msc_get_name.org_code(organization_id , sr_instance_id )
4123: from msc_supplies
4124: where plan_id = p_curr_plan_id
4125: and sr_instance_id = p_curr_inst_id
4126: and transaction_id = p_curr_trans_id;
4127:

Line 4162: from msc_supplies ms ,msc_resource_requirements mrr

4158:
4159: cursor curr_supply(p_curr_plan_id number , p_curr_inst_id number
4160: , p_curr_trans_id number ,p_operation_seq_num number ,p_resource_seq_num number) is
4161: select mrr.operation_sequence_id , ms.routing_sequence_id , ms.inventory_item_id
4162: from msc_supplies ms ,msc_resource_requirements mrr
4163: where ms.transaction_id = mrr.supply_id
4164: and ms.plan_id = mrr.plan_id
4165: and mrr.operation_seq_num = p_operation_seq_num
4166: and mrr.resource_seq_num = p_resource_seq_num

Line 4491: from msc_supplies

4487: p_transaction_id number,
4488: p_impl_alt_routing varchar2) return number is
4489: CURSOR CFM_C IS
4490: select cfm_routing_flag
4491: from msc_supplies
4492: where plan_id = p_plan_id
4493: and transaction_id = p_transaction_id
4494: and sr_instance_id = p_instance_id;
4495:

Line 4532: , p_source_table IN VARCHAR2 -- MSC_SUPPLIES or MSC_DEMANDS

4528: END check_cfm;
4529:
4530: FUNCTION load_type ( p_plan_type IN NUMBER
4531: , p_plan_id IN NUMBER
4532: , p_source_table IN VARCHAR2 -- MSC_SUPPLIES or MSC_DEMANDS
4533: , p_transaction_id IN NUMBER -- or demand_id
4534: , p_organization_id IN NUMBER
4535: , p_sr_instance_id IN NUMBER -- not reqd, but can hit U1 index with this
4536: , p_order_type IN NUMBER

Line 4559: from msc_supplies

4555: and sr_instance_id = p_sr_instance_id;
4556:
4557: cursor ir_exists IS
4558: select 1
4559: from msc_supplies
4560: where plan_id = p_plan_id
4561: and sr_instance_id = p_sr_instance_id
4562: and transaction_id in
4563: (select disposition_id

Line 4575: IF p_source_table = 'MSC_SUPPLIES' THEN

4571: l_ir_in_plan number := 0;
4572:
4573: BEGIN
4574:
4575: IF p_source_table = 'MSC_SUPPLIES' THEN
4576:
4577: -- not passed in manual release (MSCFNORD)
4578: -- select-all will always pass this
4579: IF p_cfm_routing_flag IS NULL and