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 68: from bom_operational_routings

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