APPS.PO_SUBINVENTORIES_S2 SQL Statements

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

Line: 62

  SELECT count(1)
  INTO   x_sub_count
  FROM   mtl_secondary_inventories msub,
	 mtl_system_items msi
  WHERE  msub.secondary_inventory_name = x_subinventory
  AND    msub.organization_id = x_org_id
  AND    x_transaction_date < nvl(msub.disable_date, x_transaction_date + 1)
  AND    msi.inventory_item_id = x_item_id
  AND	 msi.organization_id = x_org_id
  AND    (msi.restrict_subinventories_code = 2
          OR
	 (msi.restrict_subinventories_code = 1 and exists
	 (SELECT null
          FROM   mtl_item_sub_inventories mis
          WHERE  mis.organization_id = x_org_id
	  AND    mis.inventory_item_id = x_item_id
          AND    mis.secondary_inventory = x_subinventory)));

Line: 137

    SELECT count(1)
    INTO   x_sub_count
    FROM   mtl_secondary_inventories msub
    WHERE  msub.secondary_inventory_name = x_source_subinventory
    AND    msub.organization_id = x_source_org_id
    AND    msub.quantity_tracked = 1
    AND    decode(x_reservations, 'Y', 1, msub.reservable_type)
			                = msub.reservable_type;

Line: 216

    SELECT count(1)
    INTO   x_sub_count
    FROM   mtl_secondary_inventories msub,
	   mtl_system_items msi
    WHERE  msub.organization_id = x_source_org_id
    AND    msub.secondary_inventory_name = x_subinventory
    AND    msi.inventory_item_id = x_item_id
    AND    msi.organization_id = x_source_org_id
    AND    decode(msi.mrp_planning_code, '3', 2,
					 '4', 2, msub.availability_type)
					      = msub.availability_type;