APPS.MSC_GET_NAME dependencies on MSC_ROUTINGS

Line 1895: FROM msc_routings

1891: p_alt_rtg_desig IN VARCHAR2) return number IS
1892:
1893: CURSOR ALT_RTG_C IS
1894: SELECT cfm_routing_flag
1895: FROM msc_routings
1896: WHERE plan_id = p_plan_id
1897: AND sr_instance_id = p_instance_id
1898: AND organization_id = p_org_id
1899: AND assembly_item_id = p_item_id

Line 1904: FROM msc_routings

1900: AND alternate_routing_designator = p_alt_rtg_desig;
1901:
1902: CURSOR NULL_ALT_RTG_C IS
1903: SELECT cfm_routing_flag
1904: FROM msc_routings
1905: WHERE plan_id = p_plan_id
1906: AND sr_instance_id = p_instance_id
1907: AND organization_id = p_org_id
1908: AND assembly_item_id = p_item_id

Line 1977: FROM msc_routings

1973: p_seq_id IN NUMBER) return varchar2 IS
1974:
1975: CURSOR ALT_RTG_C IS
1976: SELECT alternate_routing_designator
1977: FROM msc_routings
1978: WHERE plan_id = p_plan_id
1979: AND sr_instance_id = p_instance_id
1980: AND routing_sequence_id = p_seq_id;
1981:

Line 2015: FROM msc_routings

2011: p_seq_id IN NUMBER) return number IS
2012:
2013: CURSOR ALT_RTG_C IS
2014: SELECT cfm_routing_flag
2015: FROM msc_routings
2016: WHERE plan_id = p_plan_id
2017: AND sr_instance_id = p_instance_id
2018: AND routing_sequence_id = p_seq_id;
2019:

Line 3862: FROM msc_routings rt,

3858: p_plan_id number,
3859: p_sr_instance_id number) return varchar2 is
3860: CURSOR ALT_RTG_C IS
3861: SELECT rt.alternate_routing_designator
3862: FROM msc_routings rt,
3863: msc_process_effectivity eff
3864: WHERE rt.plan_id = eff.plan_id
3865: AND rt.sr_instance_id = eff.sr_instance_id
3866: AND rt.routing_sequence_id = eff.routing_sequence_id

Line 4991: from msc_routings

4987: and sr_instance_id = p_instance_id;
4988:
4989: CURSOR routing_c IS
4990: select cfm_routing_flag
4991: from msc_routings
4992: where plan_id = p_plan_id
4993: and organization_id = p_org_id
4994: and assembly_item_id = p_item_id
4995: and sr_instance_id = p_instance_id