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 276: from msc_supplies ms,

272: END IF;
273:
274: select ms.new_schedule_date
275: into var_date
276: from msc_supplies ms,
277: msc_full_pegging mfp
278: where ms.transaction_id = mfp.transaction_id
279: and ms.plan_id=mfp.plan_id
280: and mfp.pegging_id = arg_pegging_id

Line 549: from msc_supplies

545: order_num varchar2(240);
546:
547: cursor order_number_c is
548: select order_number
549: from msc_supplies
550: where disposition_id in
551: (select disposition_id
552: from msc_demands
553: where plan_id = arg_plan_id

Line 562: from msc_supplies

558: and order_type in (1,2,8,11,12);
559:
560: cursor wip_entity_name_c is
561: select wip_entity_name
562: from msc_supplies
563: where disposition_id in
564: (select disposition_id
565: from msc_demands
566: where plan_id = arg_plan_id

Line 640: from msc_supplies

636: END IF;
637: -- if arg_sr_instance_id is null then
638: select order_number, order_type
639: into order_num, v_type
640: from msc_supplies
641: where transaction_id = arg_transaction_id
642: and plan_id = arg_plan_id;
643: -- else
644: select order_number, order_type

Line 646: from msc_supplies

642: and plan_id = arg_plan_id;
643: -- else
644: select order_number, order_type
645: into order_num, v_type
646: from msc_supplies
647: where transaction_id = arg_transaction_id
648: and plan_id = arg_plan_id
649: and sr_instance_id = arg_sr_instance_id;
650: -- end if;

Line 680: from msc_supplies

676: END IF;
677:
678: select lookup_meaning('MRP_ORDER_TYPE', order_type)
679: into v_order_type
680: from msc_supplies
681: where transaction_id = arg_transaction_id
682: and plan_id = arg_plan_id;
683:
684: return (v_order_type);

Line 702: from msc_supplies

698: END IF;
699:
700: select order_type
701: into v_order_type
702: from msc_supplies
703: where transaction_id = arg_transaction_id
704: and plan_id = arg_plan_id
705: and sr_instance_id = arg_instance_id;
706:

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

1452:
1453: CURSOR internal_sales(p_plan_id number,
1454: p_tran_id number, p_inst_id number) IS
1455: select ms.disposition_status_type,
1456: msc_get_name.action('MSC_SUPPLIES', msi.bom_item_type,
1457: msi.base_item_id, msi.wip_supply_type, ms.order_type,
1458: DECODE(ms.firm_planned_type,1,1,ms.reschedule_flag),
1459: ms.disposition_status_type,
1460: ms.new_schedule_date, ms.old_schedule_date,

Line 1467: from msc_supplies ms,

1463: msi.release_time_fence_code, ms.reschedule_days,
1464: ms.firm_quantity,ms.plan_id,
1465: msi.critical_component_flag, msi.mrp_planning_code,
1466: msi.lots_exist)
1467: from msc_supplies ms,
1468: msc_system_items msi
1469: where ms.plan_id = p_plan_id
1470: and ms.transaction_id = p_tran_id
1471: and ms.sr_instance_id = p_inst_id

Line 1498: msc_supplies ms

1494: CURSOR subs_excp_exist(p_plan_id number,
1495: p_supply_id number) IS
1496: select 1
1497: from msc_exception_details med,
1498: msc_supplies ms
1499: where med.plan_id = ms.plan_id
1500: and med.organization_id = ms.organization_id
1501: and med.sr_instance_id = ms.sr_instance_id
1502: and med.inventory_item_id = ms.inventory_item_id

Line 1517: msc_supplies ms,

1513:
1514: cursor transfer_order_ok_to_release is
1515: Select 1
1516: from
1517: msc_supplies ms,
1518: msc_system_items msi,
1519: msc_trading_partners mtp
1520: where
1521: ms.transaction_id = arg_trx_id

Line 1538: msc_supplies ms1

1534: and ms.batch_id is null
1535: and
1536: not exists (select 1 from msc_full_pegging mfp,
1537: msc_demands md,
1538: msc_supplies ms1
1539: where mfp.sr_instance_id = ms.sr_instance_id and
1540: mfp.plan_id = ms.plan_id and
1541: mfp.transaction_id =ms.transaction_id and
1542: mfp.demand_id =md.demand_id and

Line 1553: from msc_supplies mr,

1549: ms1.order_type =79 and rownum <2);
1550:
1551: cursor duplicate_comp (p_plan_id NUMBER, p_trx_id NUMBER) is
1552: select count(*)
1553: from msc_supplies mr,
1554: msc_demands md
1555: where mr.plan_id = md.plan_id
1556: and mr.sr_instance_id = md.sr_instance_id
1557: and mr.transaction_id = md.disposition_id

Line 1593: IF arg_source_table = 'MSC_SUPPLIES' THEN

1589: OPEN type_of_plan(arg_plan_id);
1590: FETCH type_of_plan INTO l_plan_type;
1591: CLOSE type_of_plan;
1592:
1593: IF arg_source_table = 'MSC_SUPPLIES' THEN
1594: IF arg_lots_exist = 2 and
1595: arg_order_type =5 and
1596: arg_quantity_rate <> 0 then
1597: -- plan generated planned order from supply schedule

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

1770: END IF;
1771: END IF;
1772: ELSE
1773:
1774: -- This record does note come from MSC_SUPPLIES
1775: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);
1776: IF NVL(arg_release_time_fence_code,-1) = 7 THEN
1777: -- Shikyu item
1778: RETURN l_action;

Line 2344: FROM msc_supplies

2340: FUNCTION wip_status(p_transaction_id IN NUMBER) return number IS
2341:
2342: CURSOR wip_cur IS
2343: SELECT wip_status_code
2344: FROM msc_supplies
2345: WHERE plan_id = -1
2346: and transaction_id = p_transaction_id;
2347: l_status number;
2348:

Line 3421: from msc_supplies

3417: p_transaction_id in number,
3418: p_coprod in number default 0) return varchar2 is
3419: cursor order_num_c is
3420: select wip_entity_name , order_number
3421: from msc_supplies
3422: where plan_id=p_plan_id
3423: and sr_instance_id = p_inst_id
3424: and transaction_id= p_transaction_id;
3425:

Line 3505: from msc_supplies mr,

3501: end if;
3502:
3503: select (mif.unit_weight * mr.new_order_quantity)
3504: into l_req_capacity
3505: from msc_supplies mr,
3506: msc_system_items mif
3507: where mr.plan_id = mif.plan_id
3508: and mr.sr_instance_id = mif.sr_instance_id
3509: and mr.organization_id = mif.organization_id

Line 3767: from msc_supplies

3763: END IF;
3764:
3765: select new_schedule_date
3766: into l_date
3767: from msc_supplies
3768: where transaction_id = arg_trx_id
3769: and plan_id = arg_plan_id;
3770:
3771: return l_date;

Line 4524: from msc_supplies

4520: l_supply_order_number varchar2(2000);
4521:
4522: cursor curr_supply(p_curr_plan_id number , p_curr_inst_id number , p_curr_trans_id number) is
4523: select order_number , order_type , disposition_id
4524: from msc_supplies
4525: where plan_id = p_curr_plan_id
4526: and sr_instance_id = p_curr_inst_id
4527: and transaction_id = p_curr_trans_id;
4528: begin

Line 4554: from msc_supplies

4550: l_supply_item varchar2(2000);
4551:
4552: cursor curr_supply(p_curr_plan_id number , p_curr_inst_id number , p_curr_trans_id number) is
4553: select inventory_item_id , organization_id
4554: from msc_supplies
4555: where plan_id = p_curr_plan_id
4556: and sr_instance_id = p_curr_inst_id
4557: and transaction_id = p_curr_trans_id;
4558: begin

Line 4580: from msc_supplies

4576: l_supply_org_code varchar2(100);
4577:
4578: cursor curr_supply(p_curr_plan_id number , p_curr_inst_id number , p_curr_trans_id number) is
4579: select msc_get_name.org_code(organization_id , sr_instance_id )
4580: from msc_supplies
4581: where plan_id = p_curr_plan_id
4582: and sr_instance_id = p_curr_inst_id
4583: and transaction_id = p_curr_trans_id;
4584:

Line 4619: from msc_supplies ms ,msc_resource_requirements mrr

4615:
4616: cursor curr_supply(p_curr_plan_id number , p_curr_inst_id number
4617: , p_curr_trans_id number ,p_operation_seq_num number ,p_resource_seq_num number) is
4618: select mrr.operation_sequence_id , ms.routing_sequence_id , ms.inventory_item_id
4619: from msc_supplies ms ,msc_resource_requirements mrr
4620: where ms.transaction_id = mrr.supply_id
4621: and ms.plan_id = mrr.plan_id
4622: and mrr.operation_seq_num = p_operation_seq_num
4623: and mrr.resource_seq_num = p_resource_seq_num

Line 4984: from msc_supplies

4980: p_transaction_id number,
4981: p_impl_alt_routing varchar2) return number is
4982: CURSOR CFM_C IS
4983: select cfm_routing_flag
4984: from msc_supplies
4985: where plan_id = p_plan_id
4986: and transaction_id = p_transaction_id
4987: and sr_instance_id = p_instance_id;
4988:

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

5021: END check_cfm;
5022:
5023: FUNCTION load_type ( p_plan_type IN NUMBER
5024: , p_plan_id IN NUMBER
5025: , p_source_table IN VARCHAR2 -- MSC_SUPPLIES or MSC_DEMANDS
5026: , p_transaction_id IN NUMBER -- or demand_id
5027: , p_organization_id IN NUMBER
5028: , p_sr_instance_id IN NUMBER -- not reqd, but can hit U1 index with this
5029: , p_order_type IN NUMBER

Line 5053: from msc_supplies

5049: and sr_instance_id = p_sr_instance_id;
5050:
5051: cursor ir_exists IS
5052: select 1
5053: from msc_supplies
5054: where plan_id = p_plan_id
5055: and order_type = 2
5056: and sr_instance_id = p_sr_instance_id
5057: and transaction_id in

Line 5071: IF p_source_table = 'MSC_SUPPLIES' THEN

5067:
5068:
5069: BEGIN
5070:
5071: IF p_source_table = 'MSC_SUPPLIES' THEN
5072:
5073: -- not passed in manual release (MSCFNORD)
5074: -- select-all will always pass this
5075: IF p_cfm_routing_flag IS NULL and

Line 5835: msc_get_name.action_id('MSC_SUPPLIES', msi.bom_item_type,

5831:
5832: CURSOR internal_sales(p_plan_id number,
5833: p_tran_id number, p_inst_id number) IS
5834: select ms.disposition_status_type,
5835: msc_get_name.action_id('MSC_SUPPLIES', msi.bom_item_type,
5836: msi.base_item_id, msi.wip_supply_type, ms.order_type,
5837: DECODE(ms.firm_planned_type,1,1,ms.reschedule_flag),
5838: ms.disposition_status_type,
5839: ms.new_schedule_date, ms.old_schedule_date,

Line 5846: from msc_supplies ms,

5842: msi.release_time_fence_code, ms.reschedule_days,
5843: ms.firm_quantity,ms.plan_id,
5844: msi.critical_component_flag, msi.mrp_planning_code,
5845: msi.lots_exist)
5846: from msc_supplies ms,
5847: msc_system_items msi
5848: where ms.plan_id = p_plan_id
5849: and ms.transaction_id = p_tran_id
5850: and ms.sr_instance_id = p_inst_id

Line 5906: IF arg_source_table = 'MSC_SUPPLIES' THEN

5902: OPEN type_of_plan(arg_plan_id);
5903: FETCH type_of_plan INTO l_plan_type;
5904: CLOSE type_of_plan;
5905:
5906: IF arg_source_table = 'MSC_SUPPLIES' THEN
5907: IF arg_lots_exist = 2 and
5908: arg_order_type =5 and
5909: arg_quantity_rate <> 0 then
5910: -- plan generated planned order from supply schedule

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

6052: END IF;
6053:
6054: ELSE
6055:
6056: -- This record does note come from MSC_SUPPLIES
6057: l_action := 6;
6058: IF NVL(arg_release_time_fence_code,-1) = 7 THEN
6059: -- Shikyu item
6060: RETURN l_action;

Line 6262: MSC_SUPPLIES SUPPLIES,

6258: cursor get_wip_type_c is
6259: SELECT
6260: COMPONENTS.WIP_SUPPLY_TYPE
6261: FROM
6262: MSC_SUPPLIES SUPPLIES,
6263: MSC_FULL_PEGGING PEGGING,
6264: MSC_DEMANDS DEMANDS,
6265: MSC_BOM_COMPONENTS COMPONENTS,
6266: MSC_PLANS PLANS

Line 6347: from msc_supplies ms,

6343: FUNCTION visit_name(arg_plan_id in number, arg_inst_id in number, arg_transaction_id IN NUMBER, arg_flag in number default null) return varchar2
6344: is
6345: cursor c1 is
6346: select mv.visit_id, mv.visit_name
6347: from msc_supplies ms,
6348: msc_visits mv
6349: where ms.plan_id = arg_plan_id
6350: and ms.sr_instance_id = arg_inst_id
6351: and ms.transaction_id = arg_transaction_id

Line 6385: from msc_supplies

6381: and designator_type in (12,13);
6382:
6383: cursor maint_source is
6384: select maintenance_object_source
6385: from msc_supplies
6386: where transaction_id = arg_transaction_id
6387: and plan_id = arg_plan_id
6388: and sr_instance_id = arg_sr_instance_id;
6389: