APPS.INV_KANBAN_PVT dependencies on BOM_OPERATIONAL_ROUTINGS

Line 2820: from BOM_OPERATIONAL_ROUTINGS

2816: end;
2817: IF p_Kanban_Card_Rec_Tbl(1).wip_line_id is NULL then
2818: begin
2819: select nvl(cfm_routing_flag,0),line_id into v_cfm_flag, v_wip_line_id
2820: from BOM_OPERATIONAL_ROUTINGS
2821: where
2822: assembly_item_id = p_kanban_card_rec_tbl(1).inventory_item_id AND
2823: organization_id = p_kanban_card_rec_tbl(1).organization_id AND
2824: alternate_routing_designator is NULL;

Line 2911: from BOM_OPERATIONAL_ROUTINGS

2907: ELSE /* wip line id IS not NULL */
2908:
2909: begin
2910: select nvl(cfm_routing_flag,0) into v_cfm_flag
2911: from BOM_OPERATIONAL_ROUTINGS
2912: where
2913: assembly_item_id = p_kanban_card_rec_tbl(1).inventory_item_id AND
2914: organization_id = p_kanban_card_rec_tbl(1).organization_id AND
2915: line_id = p_kanban_card_rec_tbl(1).wip_line_id AND

Line 2917: from bom_operational_routings

2913: assembly_item_id = p_kanban_card_rec_tbl(1).inventory_item_id AND
2914: organization_id = p_kanban_card_rec_tbl(1).organization_id AND
2915: line_id = p_kanban_card_rec_tbl(1).wip_line_id AND
2916: nvl(priority,0) = ( select min(nvl(priority,0))
2917: from bom_operational_routings
2918: where
2919: assembly_item_id = p_kanban_card_rec_tbl(1).inventory_item_id AND
2920: organization_id = p_kanban_card_rec_tbl(1).organization_id AND
2921: line_id = p_kanban_card_rec_tbl(1).wip_line_id ) AND

Line 3696: from BOM_OPERATIONAL_ROUTINGS

3692:
3693: BEGIN
3694: SELECT nvl(cfm_routing_flag,0)
3695: into l_cfm_flag
3696: from BOM_OPERATIONAL_ROUTINGS
3697: where
3698: assembly_item_id = l_assembly_item_id AND
3699: organization_id = l_organization_id AND
3700: alternate_routing_designator is NULL;