APPS.INV_KANBAN_PKG dependencies on MTL_ITEM_LOCATIONS

Line 44: FROM mtl_item_locations

40: RETURN (NULL);
41: ELSE
42: SELECT inv_project.get_locsegs(locator_id, org_id)
43: INTO locator_name
44: FROM mtl_item_locations
45: WHERE inventory_location_id = locator_id
46: AND organization_id = org_id;
47:
48: RETURN (locator_name);

Line 556: , mtl_item_locations mil

552: , mtl_kanban_pull_sequences mkps
553: , wip_lines wl
554: , wip_lines wl_act
555: , po_vendors pv_act
556: , mtl_item_locations mil
557: , po_vendor_sites_all pvsa_act
558: WHERE mkc.kanban_card_number LIKE (p_kanban_card_number || '%') -- 3231139
559: AND mkc.organization_id = p_org_id
560: AND mkc.inventory_item_id = NVL(p_item_id, mkc.inventory_item_id)

Line 657: mtl_item_locations_kfv milk

653: milk.concatenated_segments, wslv.inventory_item_id, locator_id
654: from
655: wsm_source_lots_v wslv,
656: bom_inventory_components bic,
657: mtl_item_locations_kfv milk
658: where
659: wslv.organization_id = p_organization_id
660: and wslv.inventory_item_id = bic.component_item_id
661: and bic.bill_sequence_id = p_bom_sequence_id