APPS.INV_UTILITIES dependencies on MTL_ITEM_LOCATIONS

Line 485: FROM mtl_item_locations

481: SELECT DISTINCT project_number
482: INTO v_proj_name
483: FROM mtl_project_v
484: WHERE project_id = (SELECT NVL(TO_NUMBER(segment19), 0)
485: FROM mtl_item_locations
486: WHERE inventory_location_id = x_loc_id
487: AND organization_id = x_org_id);
488: EXCEPTION
489: WHEN OTHERS THEN

Line 500: FROM mtl_item_locations

496: SELECT DISTINCT a.task_number
497: INTO v_task_name
498: FROM mtl_task_v a
499: WHERE a.task_id = (SELECT NVL(TO_NUMBER(segment20), 0)
500: FROM mtl_item_locations
501: WHERE inventory_location_id = x_loc_id
502: AND organization_id = x_org_id)
503: AND a.project_id = (SELECT NVL(TO_NUMBER(segment19), a.project_id)
504: FROM mtl_item_locations

Line 504: FROM mtl_item_locations

500: FROM mtl_item_locations
501: WHERE inventory_location_id = x_loc_id
502: AND organization_id = x_org_id)
503: AND a.project_id = (SELECT NVL(TO_NUMBER(segment19), a.project_id)
504: FROM mtl_item_locations
505: WHERE inventory_location_id = x_loc_id
506: AND organization_id = x_org_id);
507: EXCEPTION
508: WHEN OTHERS THEN

Line 537: 'select ' || v_loc_str || ' from mtl_item_locations where inventory_location_id = :loc_id ' || ' and organization_id = :org_id';

533: END LOOP;
534:
535: IF v_loc_str IS NOT NULL THEN
536: v_parse_str :=
537: 'select ' || v_loc_str || ' from mtl_item_locations where inventory_location_id = :loc_id ' || ' and organization_id = :org_id';
538: dsql_cur := DBMS_SQL.open_cursor;
539: DBMS_SQL.parse(dsql_cur, v_parse_str, DBMS_SQL.native);
540: DBMS_SQL.define_column(dsql_cur, 1, d_data_str, 800);
541: DBMS_SQL.bind_variable(dsql_cur, 'loc_id', x_loc_id);

Line 616: FROM mtl_item_locations mil, cst_cg_item_costs_view ccicv, mtl_parameters mp

612: AND ccicv.organization_id = mp.organization_id
613: AND ccicv.cost_group_id = DECODE(mp.primary_cost_method, 1, 1, NVL(mp.default_cost_group_id, 1))
614: UNION ALL
615: SELECT NVL(ccicv.item_cost, 0)
616: FROM mtl_item_locations mil, cst_cg_item_costs_view ccicv, mtl_parameters mp
617: WHERE v_locator_id IS NOT NULL
618: AND mil.organization_id = v_org_id
619: AND mil.inventory_location_id = v_locator_id
620: AND mil.project_id IS NULL

Line 627: FROM mtl_item_locations mil, mrp_project_parameters mrp, cst_cg_item_costs_view ccicv, mtl_parameters mp

623: AND ccicv.organization_id = mp.organization_id
624: AND ccicv.cost_group_id = DECODE(mp.primary_cost_method, 1, 1, DECODE(l_wms_enabled_flag,'Y',ccicv.cost_group_id, NVL(mp.default_cost_group_id, 1)))
625: UNION ALL
626: SELECT NVL(ccicv.item_cost, 0)
627: FROM mtl_item_locations mil, mrp_project_parameters mrp, cst_cg_item_costs_view ccicv, mtl_parameters mp
628: WHERE v_locator_id IS NOT NULL
629: AND mil.organization_id = v_org_id
630: AND mil.inventory_location_id = v_locator_id
631: AND mil.project_id IS NOT NULL