1485: select segment1 into v_problem_config from mtl_system_items
1486: where inventory_item_id = pConfigId and rownum = 1 ;
1487:
1488: -- rkaza. bug 3742393. 08/11/2004. Replaced org_organization
1489: -- _deinitions with inv_organization_name_v
1490: select organization_name into v_error_org from inv_organization_name_v
1491: where organization_id = pOrgId ;
1492:
1493:
1486: where inventory_item_id = pConfigId and rownum = 1 ;
1487:
1488: -- rkaza. bug 3742393. 08/11/2004. Replaced org_organization
1489: -- _deinitions with inv_organization_name_v
1490: select organization_name into v_error_org from inv_organization_name_v
1491: where organization_id = pOrgId ;
1492:
1493:
1494: v_problem_model_line_num := ' -1 ' ;
1535: select segment1 into v_problem_config from mtl_system_items
1536: where inventory_item_id = pConfigId and rownum = 1 ;
1537:
1538: -- rkaza. bug 3742393. 08/11/2004. Replaced org_organization
1539: -- _deinitions with inv_organization_name_v
1540:
1541: select organization_name into v_error_org from inv_organization_name_v
1542: where organization_id = pOrgId ;
1543:
1537:
1538: -- rkaza. bug 3742393. 08/11/2004. Replaced org_organization
1539: -- _deinitions with inv_organization_name_v
1540:
1541: select organization_name into v_error_org from inv_organization_name_v
1542: where organization_id = pOrgId ;
1543:
1544:
1545: v_problem_model_line_num := ' -1 ' ;
1611: select segment1 into v_problem_config from mtl_system_items
1612: where inventory_item_id = pConfigId and rownum = 1 ;
1613:
1614: -- rkaza. bug 3742393. 08/11/2004. Replaced org_organization
1615: -- _deinitions with inv_organization_name_v
1616:
1617: select organization_name into v_error_org from inv_organization_name_v
1618: where organization_id = pOrgId ;
1619:
1613:
1614: -- rkaza. bug 3742393. 08/11/2004. Replaced org_organization
1615: -- _deinitions with inv_organization_name_v
1616:
1617: select organization_name into v_error_org from inv_organization_name_v
1618: where organization_id = pOrgId ;
1619:
1620:
1621:
1765: select segment1 into v_problem_config from mtl_system_items
1766: where inventory_item_id = pConfigId and rownum = 1 ;
1767:
1768: -- rkaza. bug 3742393. 08/11/2004. Replaced org_organization
1769: -- _deinitions with inv_organization_name_v
1770: select organization_name into v_error_org from inv_organization_name_v
1771: where organization_id = pOrgId ;
1772:
1773:
1766: where inventory_item_id = pConfigId and rownum = 1 ;
1767:
1768: -- rkaza. bug 3742393. 08/11/2004. Replaced org_organization
1769: -- _deinitions with inv_organization_name_v
1770: select organization_name into v_error_org from inv_organization_name_v
1771: where organization_id = pOrgId ;
1772:
1773:
1774: select oel.line_number || '.' || oel.shipment_number
2530: and organization_id = porgid;
2531:
2532: select organization_name
2533: into l_org_name
2534: from inv_organization_name_v
2535: where organization_id = porgid;
2536:
2537: --l_token(1).token_name := 'ERROR_COMPONENTS';
2538: --l_token(1).token_value := v_diff_basis_string ;