APPS.MSC_GET_NAME dependencies on MSC_ROUTINGS

Line 1566: FROM msc_routings

1562: p_alt_rtg_desig IN VARCHAR2) return number IS
1563:
1564: CURSOR ALT_RTG_C IS
1565: SELECT cfm_routing_flag
1566: FROM msc_routings
1567: WHERE plan_id = p_plan_id
1568: AND sr_instance_id = p_instance_id
1569: AND organization_id = p_org_id
1570: AND assembly_item_id = p_item_id

Line 1575: FROM msc_routings

1571: AND alternate_routing_designator = p_alt_rtg_desig;
1572:
1573: CURSOR NULL_ALT_RTG_C IS
1574: SELECT cfm_routing_flag
1575: FROM msc_routings
1576: WHERE plan_id = p_plan_id
1577: AND sr_instance_id = p_instance_id
1578: AND organization_id = p_org_id
1579: AND assembly_item_id = p_item_id

Line 1633: FROM msc_routings

1629: p_seq_id IN NUMBER) return varchar2 IS
1630:
1631: CURSOR ALT_RTG_C IS
1632: SELECT alternate_routing_designator
1633: FROM msc_routings
1634: WHERE plan_id = p_plan_id
1635: AND sr_instance_id = p_instance_id
1636: AND routing_sequence_id = p_seq_id;
1637:

Line 1661: FROM msc_routings

1657: p_seq_id IN NUMBER) return number IS
1658:
1659: CURSOR ALT_RTG_C IS
1660: SELECT cfm_routing_flag
1661: FROM msc_routings
1662: WHERE plan_id = p_plan_id
1663: AND sr_instance_id = p_instance_id
1664: AND routing_sequence_id = p_seq_id;
1665:

Line 3405: FROM msc_routings rt,

3401: p_plan_id number,
3402: p_sr_instance_id number) return varchar2 is
3403: CURSOR ALT_RTG_C IS
3404: SELECT rt.alternate_routing_designator
3405: FROM msc_routings rt,
3406: msc_process_effectivity eff
3407: WHERE rt.plan_id = eff.plan_id
3408: AND rt.sr_instance_id = eff.sr_instance_id
3409: AND rt.routing_sequence_id = eff.routing_sequence_id

Line 4498: from msc_routings

4494: and sr_instance_id = p_instance_id;
4495:
4496: CURSOR routing_c IS
4497: select cfm_routing_flag
4498: from msc_routings
4499: where plan_id = p_plan_id
4500: and organization_id = p_org_id
4501: and assembly_item_id = p_item_id
4502: and sr_instance_id = p_instance_id