APPS.INV_KANBAN_PVT dependencies on BOM_OPERATIONAL_ROUTINGS

Line 3216: from BOM_OPERATIONAL_ROUTINGS

3212: end;
3213: IF p_Kanban_Card_Rec_Tbl(1).wip_line_id is NULL then
3214: begin
3215: select nvl(cfm_routing_flag,0),line_id into v_cfm_flag, v_wip_line_id
3216: from BOM_OPERATIONAL_ROUTINGS
3217: where
3218: assembly_item_id = p_kanban_card_rec_tbl(1).inventory_item_id AND
3219: organization_id = p_kanban_card_rec_tbl(1).organization_id AND
3220: alternate_routing_designator is NULL;

Line 3307: from BOM_OPERATIONAL_ROUTINGS

3303: ELSE /* wip line id IS not NULL */
3304:
3305: begin
3306: select nvl(cfm_routing_flag,0) into v_cfm_flag
3307: from BOM_OPERATIONAL_ROUTINGS
3308: where
3309: assembly_item_id = p_kanban_card_rec_tbl(1).inventory_item_id AND
3310: organization_id = p_kanban_card_rec_tbl(1).organization_id AND
3311: line_id = p_kanban_card_rec_tbl(1).wip_line_id AND

Line 3313: from bom_operational_routings

3309: assembly_item_id = p_kanban_card_rec_tbl(1).inventory_item_id AND
3310: organization_id = p_kanban_card_rec_tbl(1).organization_id AND
3311: line_id = p_kanban_card_rec_tbl(1).wip_line_id AND
3312: nvl(priority,0) = ( select min(nvl(priority,0))
3313: from bom_operational_routings
3314: where
3315: assembly_item_id = p_kanban_card_rec_tbl(1).inventory_item_id AND
3316: organization_id = p_kanban_card_rec_tbl(1).organization_id AND
3317: line_id = p_kanban_card_rec_tbl(1).wip_line_id ) AND

Line 4097: from BOM_OPERATIONAL_ROUTINGS

4093:
4094: BEGIN
4095: SELECT nvl(cfm_routing_flag,0)
4096: into l_cfm_flag
4097: from BOM_OPERATIONAL_ROUTINGS
4098: where
4099: assembly_item_id = l_assembly_item_id AND
4100: organization_id = l_organization_id AND
4101: alternate_routing_designator is NULL;