APPS.INV_UTILITIES dependencies on MTL_ITEM_LOCATIONS

Line 653: FROM mtl_item_locations

649: SELECT DISTINCT project_number
650: INTO v_proj_name
651: FROM mtl_project_v
652: WHERE project_id = (SELECT NVL(TO_NUMBER(segment19), 0)
653: FROM mtl_item_locations
654: WHERE inventory_location_id = x_loc_id
655: AND organization_id = x_org_id);
656: EXCEPTION
657: WHEN OTHERS THEN

Line 668: FROM mtl_item_locations

664: SELECT DISTINCT a.task_number
665: INTO v_task_name
666: FROM mtl_task_v a
667: WHERE a.task_id = (SELECT NVL(TO_NUMBER(segment20), 0)
668: FROM mtl_item_locations
669: WHERE inventory_location_id = x_loc_id
670: AND organization_id = x_org_id)
671: AND a.project_id = (SELECT NVL(TO_NUMBER(segment19), a.project_id)
672: FROM mtl_item_locations

Line 672: FROM mtl_item_locations

668: FROM mtl_item_locations
669: WHERE inventory_location_id = x_loc_id
670: AND organization_id = x_org_id)
671: AND a.project_id = (SELECT NVL(TO_NUMBER(segment19), a.project_id)
672: FROM mtl_item_locations
673: WHERE inventory_location_id = x_loc_id
674: AND organization_id = x_org_id);
675: EXCEPTION
676: WHEN OTHERS THEN

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

701: END LOOP;
702:
703: IF v_loc_str IS NOT NULL THEN
704: v_parse_str :=
705: 'select ' || v_loc_str || ' from mtl_item_locations where inventory_location_id = :loc_id ' || ' and organization_id = :org_id';
706: dsql_cur := DBMS_SQL.open_cursor;
707: DBMS_SQL.parse(dsql_cur, v_parse_str, DBMS_SQL.native);
708: DBMS_SQL.define_column(dsql_cur, 1, d_data_str, 800);
709: DBMS_SQL.bind_variable(dsql_cur, 'loc_id', x_loc_id);

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

780: AND ccicv.organization_id = mp.organization_id
781: AND ccicv.cost_group_id = DECODE(mp.primary_cost_method, 1, 1, NVL(mp.default_cost_group_id, 1))
782: UNION ALL
783: SELECT NVL(ccicv.item_cost, 0)
784: FROM mtl_item_locations mil, cst_cg_item_costs_view ccicv, mtl_parameters mp
785: WHERE v_locator_id IS NOT NULL
786: AND mil.organization_id = v_org_id
787: AND mil.inventory_location_id = v_locator_id
788: AND mil.project_id IS NULL

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

791: AND ccicv.organization_id = mp.organization_id
792: 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)))
793: UNION ALL
794: SELECT NVL(ccicv.item_cost, 0)
795: FROM mtl_item_locations mil, mrp_project_parameters mrp, cst_cg_item_costs_view ccicv, mtl_parameters mp
796: WHERE v_locator_id IS NOT NULL
797: AND mil.organization_id = v_org_id
798: AND mil.inventory_location_id = v_locator_id
799: AND mil.project_id IS NOT NULL