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 545: , mtl_item_locations mil

541: , mtl_kanban_pull_sequences mkps
542: , wip_lines wl
543: , wip_lines wl_act
544: , po_vendors pv_act
545: , mtl_item_locations mil
546: , po_vendor_sites_all pvsa_act
547: WHERE mkc.kanban_card_number LIKE (p_kanban_card_number || '%') -- 3231139
548: AND mkc.organization_id = p_org_id
549: AND mkc.inventory_item_id = NVL(p_item_id, mkc.inventory_item_id)

Line 646: mtl_item_locations_kfv milk

642: milk.concatenated_segments, wslv.inventory_item_id, locator_id
643: from
644: wsm_source_lots_v wslv,
645: bom_inventory_components bic,
646: mtl_item_locations_kfv milk
647: where
648: wslv.organization_id = p_organization_id
649: and wslv.inventory_item_id = bic.component_item_id
650: and bic.bill_sequence_id = p_bom_sequence_id