APPS.WIP_CFM_FILTER dependencies on BOM_OPERATIONAL_ROUTINGS

Line 19: from bom_operational_routings

15: * match to the item and organization.
16: */
17: cursor routing_flags is
18: select nvl(cfm_routing_flag,2) as value
19: from bom_operational_routings
20: where assembly_item_id = p_item_id
21: and organization_id = p_organization_id
22: and alternate_routing_designator is null;
23:

Line 26: from bom_operational_routings

22: and alternate_routing_designator is null;
23:
24: cursor routing_flags1 is
25: select nvl(cfm_routing_flag,2) as value
26: from bom_operational_routings
27: where assembly_item_id = p_item_id
28: and organization_id = p_organization_id
29: and alternate_routing_designator is not null;
30:

Line 70: from bom_operational_routings

66: * There should be at most one match.
67: */
68: cursor routing_flags is
69: select nvl(cfm_routing_flag,2)
70: from bom_operational_routings
71: where assembly_item_id = p_item_id
72: and organization_id = p_organization_id
73: and ((p_alternate_routing_designator is null
74: and alternate_routing_designator is null)