1459: select segment1 into v_problem_config from mtl_system_items
1460: where inventory_item_id = pConfigId and rownum = 1 ;
1461:
1462: -- rkaza. bug 3742393. 08/11/2004. Replaced org_organization
1463: -- _deinitions with inv_organization_name_v
1464: select organization_name into v_error_org from inv_organization_name_v
1465: where organization_id = pOrgId ;
1466:
1467:
1460: where inventory_item_id = pConfigId and rownum = 1 ;
1461:
1462: -- rkaza. bug 3742393. 08/11/2004. Replaced org_organization
1463: -- _deinitions with inv_organization_name_v
1464: select organization_name into v_error_org from inv_organization_name_v
1465: where organization_id = pOrgId ;
1466:
1467:
1468: v_problem_model_line_num := ' -1 ' ;
1509: select segment1 into v_problem_config from mtl_system_items
1510: where inventory_item_id = pConfigId and rownum = 1 ;
1511:
1512: -- rkaza. bug 3742393. 08/11/2004. Replaced org_organization
1513: -- _deinitions with inv_organization_name_v
1514:
1515: select organization_name into v_error_org from inv_organization_name_v
1516: where organization_id = pOrgId ;
1517:
1511:
1512: -- rkaza. bug 3742393. 08/11/2004. Replaced org_organization
1513: -- _deinitions with inv_organization_name_v
1514:
1515: select organization_name into v_error_org from inv_organization_name_v
1516: where organization_id = pOrgId ;
1517:
1518:
1519: v_problem_model_line_num := ' -1 ' ;
1585: select segment1 into v_problem_config from mtl_system_items
1586: where inventory_item_id = pConfigId and rownum = 1 ;
1587:
1588: -- rkaza. bug 3742393. 08/11/2004. Replaced org_organization
1589: -- _deinitions with inv_organization_name_v
1590:
1591: select organization_name into v_error_org from inv_organization_name_v
1592: where organization_id = pOrgId ;
1593:
1587:
1588: -- rkaza. bug 3742393. 08/11/2004. Replaced org_organization
1589: -- _deinitions with inv_organization_name_v
1590:
1591: select organization_name into v_error_org from inv_organization_name_v
1592: where organization_id = pOrgId ;
1593:
1594:
1595:
1739: select segment1 into v_problem_config from mtl_system_items
1740: where inventory_item_id = pConfigId and rownum = 1 ;
1741:
1742: -- rkaza. bug 3742393. 08/11/2004. Replaced org_organization
1743: -- _deinitions with inv_organization_name_v
1744: select organization_name into v_error_org from inv_organization_name_v
1745: where organization_id = pOrgId ;
1746:
1747:
1740: where inventory_item_id = pConfigId and rownum = 1 ;
1741:
1742: -- rkaza. bug 3742393. 08/11/2004. Replaced org_organization
1743: -- _deinitions with inv_organization_name_v
1744: select organization_name into v_error_org from inv_organization_name_v
1745: where organization_id = pOrgId ;
1746:
1747:
1748: select oel.line_number || '.' || oel.shipment_number
2470: and organization_id = porgid;
2471:
2472: select organization_name
2473: into l_org_name
2474: from inv_organization_name_v
2475: where organization_id = porgid;
2476:
2477: --l_token(1).token_name := 'ERROR_COMPONENTS';
2478: --l_token(1).token_value := v_diff_basis_string ;