APPS.PO_ORGS_SV2 SQL Statements

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

Line: 28

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

Line: 57

      ** at this point, the decode allows this SELECT to succeed.
      */

      x_progress := '020';

Line: 62

      SELECT count(1)
      INTO   x_org_count
      FROM   mtl_system_items msi
      WHERE  msi.organization_id = x_destination_org_id
      AND    msi.inventory_item_id = x_item_id
      AND    msi.stock_enabled_flag = 'Y'
      AND    decode(x_source_type, 'VENDOR', 'Y',
		  msi.purchasing_enabled_flag) = msi.purchasing_enabled_flag
      AND    (x_item_revision is null
	      OR
	      x_destination_org_id in
	      (SELECT mir.organization_id
     	       FROM   mtl_item_revisions mir
               WHERE  mir.inventory_item_id = x_item_id
	       AND    mir.revision = x_item_revision));

Line: 83

      ** at this point, the decode allows this SELECT to succeed.
      */

       x_progress := '040';

Line: 88

       SELECT count(1)
       INTO   x_org_count
       FROM   mtl_system_items msi
       WHERE  msi.organization_id = x_destination_org_id
       AND    msi.inventory_item_id = x_item_id
       AND    decode(x_source_type, 'VENDOR', 'Y',
                  msi.purchasing_enabled_flag) = msi.purchasing_enabled_flag;

Line: 104

      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_destination_org_id
      AND    msi.purchasing_enabled_flag = 'Y'
      AND    msi.outside_operation_flag = 'Y';

Line: 169

    SELECT mip.intransit_type
    INTO   x_intransit_type
    FROM   org_organization_definitions ood,
	 mtl_system_items msi,
	 mtl_interorg_parameters mip
    WHERE  ood.organization_id = x_source_org_id
    AND    sysdate < nvl(ood.disable_date, sysdate + 1)
    AND	 mip.from_organization_id = x_source_org_id
    AND	 mip.to_organization_id = x_destination_org_id
    AND	 msi.organization_id = x_source_org_id
    AND    msi.inventory_item_id = x_item_id
    AND	 msi.internal_order_enabled_flag = 'Y'
    AND    msi.stock_enabled_flag = 'Y'
    AND    (x_item_revision is null
	  OR
	  x_source_org_id in
	  (SELECT mir.organization_id
     	   FROM   mtl_item_revisions mir
           WHERE  mir.inventory_item_id = x_item_id
	   AND    mir.revision = x_item_revision));

Line: 215

      SELECT count(1)
      INTO   x_org_count
      FROM   mtl_system_items msi1,
  	   mtl_system_items msi2
      WHERE  msi1.inventory_item_id = x_item_id
      AND    msi1.organization_id = x_source_org_id
      AND    msi2.inventory_item_id = x_item_id
      AND    msi2.organization_id = x_destination_org_id
      AND    ((msi1.lot_control_code = 1 AND
             msi2.lot_control_code = 2)
             OR
             (msi1.serial_number_control_code in (1) AND
	      msi2.serial_number_control_code in (2,3,5))
	     OR
	     (msi1.revision_qty_control_code = 1 AND
	      msi2.revision_qty_control_code = 2));

Line: 243

    SELECT 'Y'
    INTO   l_internal_ordered
    FROM   org_organization_definitions ood,
         mtl_system_items msi
    WHERE  ood.organization_id = x_source_org_id
    AND    sysdate < nvl(ood.disable_date, sysdate + 1)
    AND  msi.organization_id = x_source_org_id
    AND    msi.inventory_item_id = x_item_id
    AND  msi.internal_order_enabled_flag = 'Y'
    AND    msi.stock_enabled_flag = 'Y'
    AND    (x_item_revision is null
          OR
          x_source_org_id in
          (SELECT mir.organization_id
           FROM   mtl_item_revisions mir
           WHERE  mir.inventory_item_id = x_item_id
           AND    mir.revision = x_item_revision));