APPS.INV_AUTODETAIL dependencies on MTL_ITEM_LOCATIONS

Line 264: FROM mtl_item_locations

260: AND organization_id = l_organization_id ;
261: */ --
262: CURSOR l_locator_status_csr IS
263: SELECT status_id
264: FROM mtl_item_locations
265: WHERE inventory_location_id = l_putaway_loc
266: AND organization_id = l_organization_id ;
267: --
268: CURSOR l_locator_csr IS

Line 271: mtl_item_locations mil

267: --
268: CURSOR l_locator_csr IS
269: SELECT locator_id
270: FROM mtl_item_loc_defaults mtld,
271: mtl_item_locations mil
272: WHERE mtld.locator_id = mil.inventory_location_id
273: AND mtld.organization_id = mil.organization_id
274: AND mtld.inventory_item_id = l_inventory_item_id
275: AND mtld.organization_id = l_organization_id

Line 521: ' FROM mtl_item_locations ' || g_line_feed ||

517: x_where_clause := ' AND '||
518: ' ((base.locator_id IS NULL) OR ' || g_line_feed ||
519: ' (base.locator_id IS NOT NULL AND (EXISTS ( ' || g_line_feed ||
520: ' SELECT inventory_location_id ' || g_line_feed ||
521: ' FROM mtl_item_locations ' || g_line_feed ||
522: ' WHERE inventory_location_id = base.locator_id'|| g_line_feed ||
523: ' AND organization_id = base.organization_id' || g_line_feed ||
524: ' AND project_id IS NULL ' || g_line_feed ||
525: ' AND task_id IS NULL)))) ';

Line 536: ' FROM mtl_item_locations ' || g_line_feed ||

532: l_identifier := inv_sql_binding_pvt.initbindvar(p_project_id);
533: x_where_clause :=' AND '||
534: ' ((base.locator_id IS NOT NULL) AND (EXISTS ( ' || g_line_feed ||
535: ' SELECT inventory_location_id ' || g_line_feed ||
536: ' FROM mtl_item_locations ' || g_line_feed ||
537: ' WHERE inventory_location_id = base.locator_id ' || g_line_feed ||
538: ' AND organization_id = base.organization_id ' || g_line_feed ||
539: ' AND nvl(project_id,' || l_identifier || ') = ' || g_line_feed ||
540: l_identifier || g_line_feed ||

Line 550: ' FROM mtl_item_locations ' || g_line_feed ||

546: l_id2 := inv_sql_binding_pvt.initbindvar(p_task_id);
547: x_where_clause :=' AND '||
548: ' ((base.locator_id IS NOT NULL) AND (EXISTS ( '|| g_line_feed ||
549: ' SELECT inventory_location_id ' || g_line_feed ||
550: ' FROM mtl_item_locations ' || g_line_feed ||
551: ' WHERE inventory_location_id = base.locator_id ' || g_line_feed ||
552: ' AND organization_id = base.organization_id ' || g_line_feed ||
553: ' AND ((project_id = ' || g_line_feed ||
554: l_identifier || g_line_feed ||

Line 571: ' FROM mtl_item_locations ' || g_line_feed ||

567: l_identifier := inv_sql_binding_pvt.initbindvar(p_project_id);
568: x_where_clause :=' AND '||
569: ' ((base.locator_id IS NOT NULL) AND (EXISTS ( ' || g_line_feed ||
570: ' SELECT inventory_location_id ' || g_line_feed ||
571: ' FROM mtl_item_locations ' || g_line_feed ||
572: ' WHERE inventory_location_id = base.locator_id ' || g_line_feed ||
573: ' AND organization_id = base.organization_id ' || g_line_feed ||
574: ' AND project_id = ' || g_line_feed ||
575: l_identifier || g_line_feed ||

Line 586: ' FROM mtl_item_locations ' || g_line_feed ||

582: l_id2 := inv_sql_binding_pvt.initbindvar(p_task_id);
583: x_where_clause :=' AND '||
584: ' ((base.locator_id IS NOT NULL) AND (EXISTS ( '|| g_line_feed ||
585: ' SELECT inventory_location_id ' || g_line_feed ||
586: ' FROM mtl_item_locations ' || g_line_feed ||
587: ' WHERE inventory_location_id = base.locator_id ' || g_line_feed ||
588: ' AND organization_id = base.organization_id ' || g_line_feed ||
589: ' AND project_id = ' || g_line_feed ||
590: l_identifier || g_line_feed ||

Line 956: l_from := l_from || ',mtl_item_locations mil';

952: -- -------------------------------------------
953: -- Fourth, picking rule pertaining to locator
954: -- -------------------------------------------
955: IF l_loc_rule = 2 THEN -- Locator Picking Order
956: l_from := l_from || ',mtl_item_locations mil';
957: l_loc_where := l_loc_where
958: || g_line_feed || ' AND base.locator_id = mil.inventory_location_id(+) '
959: || g_line_feed || ' AND base.organization_id = mil.organization_id (+) ';
960: l_loc_select := ' , mil.picking_order';