APPS.PO_ORGS_SV SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 26

          ** Please Note that this select DOES NOT fetch the ORG_ID back
          ** as it is already a part of the where clause. R10 code always
          ** selects it into a bind variable. This means that the procedure
          ** that calls this api should take care of that logic if necessary */

          select  ood.organization_code,
                  ood.organization_name
          into    X_org_code,
                  X_org_name
          from org_organization_definitions ood
          where ood.organization_id(+) = X_org_id;

Line: 87

     SELECT count(1)
     INTO   x_org_count
     FROM   org_organization_definitions ood
     WHERE  ood.set_of_books_id = x_sob_id
     AND    ood.organization_id = x_org_id
     AND    nvl(ood.disable_date, trunc(sysdate + 1)) > trunc(sysdate);

Line: 113

	      SELECT count(1)
	      INTO   x_org_count
	      FROM   mtl_system_items  msi
	      WHERE  msi.inventory_item_id = x_item_id
	      AND    msi.stock_enabled_flag = 'Y'
	      AND    msi.purchasing_enabled_flag = 'Y'
	      AND    msi.organization_id = x_org_id;

Line: 122

	      SELECT count(1)
	      INTO   x_org_count
	      FROM   mtl_system_items  msi
	      WHERE  msi.stock_enabled_flag = 'Y'
	      AND    msi.purchasing_enabled_flag = 'Y'
	      AND    msi.organization_id = x_org_id
              AND    ROWNUM <   2;

Line: 143

	     SELECT count(1)
	     INTO   x_org_count
	     FROM   mtl_system_items msi
	     WHERE  msi.inventory_item_id = x_item_id
	     AND    msi.organization_id = x_org_id;

Line: 149

	     SELECT count(1)
	     INTO   x_org_count
	     FROM   mtl_system_items msi
	     WHERE  msi.organization_id = x_org_id
             AND    ROWNUM <   2;

Line: 168

	     SELECT count(1)
	     INTO   x_org_count
	     FROM   mtl_system_items msi
	     WHERE  msi.inventory_item_id = x_item_id
	     AND    msi.organization_id = x_org_id
	     AND    msi.outside_operation_flag = 'Y';

Line: 175

	     SELECT count(1)
	     INTO   x_org_count
	     FROM   mtl_system_items msi
	     WHERE  msi.organization_id = x_org_id
	     AND    msi.outside_operation_flag = 'Y'
             AND    ROWNUM <   2;

Line: 198

     SELECT count(1)
     INTO   x_org_count
     FROM   mtl_item_revisions mir
     WHERE  mir.revision = nvl(x_item_rev, mir.revision)
     AND    mir.inventory_item_id = x_item_id
     AND    mir.organization_id = x_org_id;

Line: 267

     SELECT count(1)
     INTO   x_org_count
     FROM   org_organization_definitions ood
     WHERE  ood.set_of_books_id = x_sob_id
     AND    ood.organization_id = x_src_org_id
     AND    nvl(ood.disable_date, trunc(sysdate + 1)) > trunc(sysdate);

Line: 306

      SELECT count(1)
      INTO   x_org_count
      FROM   mtl_system_items msi
      WHERE  msi.organization_id = x_src_org_id
      AND    msi.inventory_item_id = x_item_id
      AND    msi.stock_enabled_flag = 'Y'
      AND    msi.internal_order_enabled_flag = 'Y';

Line: 329

     SELECT mip.intransit_type
     INTO   x_intransit_type
     FROM   mtl_interorg_parameters mip
     WHERE  mip.from_organization_id  = x_src_org_id
     AND    mip.to_organization_id = x_dest_org_id;

Line: 347

    SELECT count(1)
    INTO   x_org_count
    FROM   mtl_system_items ms1,
           mtl_system_items ms2
    WHERE  ms1.inventory_item_id = x_item_id
    AND    ms1.organization_id   = x_src_org_id
    AND    ms2.inventory_item_id = x_item_id
    AND    ms2.organization_id   = x_dest_org_id
    AND    ((ms1.lot_control_code = 1 AND
	     ms2.lot_control_code = 2)
	   OR (ms1.serial_number_control_code IN (1)
	   AND ms2.serial_number_control_code IN (2,3,5))
	   OR (ms1.revision_qty_control_code = 1
	   AND ms2.revision_qty_control_code = 2));

Line: 419

    	 SELECT organization_code, organization_id INTO   x_org_code, x_org_id
     	 FROM   mtl_parameters
    	 WHERE  organization_code = p_org_record.organization_code
      	 AND organization_id = p_org_record.organization_id;

Line: 430

     	 SELECT organization_code, organization_id INTO   x_org_code, x_org_id
     	 FROM   mtl_parameters
	 WHERE organization_code = p_org_record.organization_code;

Line: 440

     	 SELECT organization_code, organization_id INTO   x_org_code, x_org_id
     	 FROM   mtl_parameters
     	 WHERE  organization_id = p_org_record.organization_id;

Line: 502

     SELECT organization_id
     INTO   x_organization_id
     FROM   mtl_parameters
     WHERE  organization_code = p_org_record.organization_code;

Line: 518

       SELECT user_definition_enable_date,
              disable_date,
              organization_code
       INTO   x_date_table(x_organization_id).v_enable_date,
              x_date_table(x_organization_id).v_disable_date,
              x_date_table(x_organization_id).v_organization_code
       FROM   org_organization_definitions
       WHERE  organization_id = x_organization_id;

Line: 527

       SELECT user_definition_enable_date,
              disable_date,
              organization_code
       INTO   x_date_table(x_organization_id).v_enable_date,
              x_date_table(x_organization_id).v_disable_date,
              x_date_table(x_organization_id).v_organization_code
       FROM   org_organization_definitions
       WHERE  organization_id = x_organization_id AND
              organization_code = x_organization_code;

Line: 569

    X_sql_str := 'SELECT user_definition_enable_date, disable_date FROM org_organization_definitions WHERE ';